import altair as alt # Loading the altair library
import pandas as pd
alt.data_transformers.disable_max_rows()
DataTransformerRegistry.enable('default')
# data from 2012
# https://drive.google.com/file/d/1fXJjst0rrlrFauppA8odQXOrdCEcmLaN/view?usp=sharing
Chicago = pd.read_csv('https://drive.google.com/uc?id=1fXJjst0rrlrFauppA8odQXOrdCEcmLaN')
Chicago
| ID | Case Number | Date | Block | IUCR | Primary Type | Description | Location Description | Arrest | Domestic | ... | Location | Historical Wards 2003-2015 | Zip Codes | Community Areas | Census Tracts | Wards | Boundaries - ZIP Codes | Police Districts | Police Beats | Wards 2023- | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 8953937 | HW102973 | 12/31/2012 11:58:00 PM | 037XX N NORA AVE | 0610 | BURGLARY | FORCIBLE ENTRY | RESIDENCE-GARAGE | False | False | ... | (41.947761848, -87.802170774) | 39.0 | 22254.0 | 17.0 | 444.0 | 19.0 | 52.0 | 12.0 | 17.0 | 38.0 |
| 1 | 8954299 | HW100700 | 12/31/2012 11:55:00 PM | 058XX S MARYLAND AVE | 0890 | THEFT | FROM BUILDING | HOSPITAL BUILDING/GROUNDS | False | False | ... | (41.788699253, -87.604954085) | 32.0 | 22260.0 | 8.0 | 154.0 | 33.0 | 60.0 | 24.0 | 132.0 | 3.0 |
| 2 | 8950836 | HW100039 | 12/31/2012 11:55:00 PM | 0000X E OHIO ST | 2890 | PUBLIC PEACE VIOLATION | OTHER VIOLATION | SIDEWALK | True | False | ... | (41.892507592, -87.626223996) | 22.0 | 21182.0 | 37.0 | 626.0 | 36.0 | 6.0 | 14.0 | 74.0 | 42.0 |
| 3 | 8950918 | HW100021 | 12/31/2012 11:55:00 PM | 035XX W MONTROSE AVE | 0610 | BURGLARY | FORCIBLE ENTRY | OTHER | False | False | ... | (41.961089289, -87.716314748) | 2.0 | 21538.0 | 16.0 | 56.0 | 12.0 | 39.0 | 1.0 | 9.0 | 33.0 |
| 4 | 8951459 | HW100757 | 12/31/2012 11:50:00 PM | 028XX N HALSTED ST | 0890 | THEFT | FROM BUILDING | RESIDENCE | False | False | ... | (41.933894393, -87.649052922) | 38.0 | 4449.0 | 57.0 | 684.0 | 25.0 | 22.0 | 5.0 | 30.0 | 44.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 336320 | 8678186 | HV352296 | 01/01/2012 12:00:00 AM | 013XX W WASHBURNE AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | False | ... | (41.866098868, -87.659865054) | 48.0 | 14920.0 | 29.0 | 96.0 | 26.0 | 43.0 | 15.0 | 150.0 | 28.0 |
| 336321 | 8647985 | HV322951 | 01/01/2012 12:00:00 AM | 015XX N CAMPBELL AVE | 1305 | CRIMINAL DAMAGE | CRIMINAL DEFACEMENT | RESIDENCE-GARAGE | False | False | ... | (41.909296674, -87.689653613) | 10.0 | 21560.0 | 25.0 | 302.0 | 41.0 | 4.0 | 7.0 | 62.0 | 1.0 |
| 336322 | 8511440 | HV188411 | 01/01/2012 12:00:00 AM | 030XX W 64TH ST | 0840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | ... | (41.777209768, -87.69903082) | 44.0 | 21867.0 | 64.0 | 319.0 | 31.0 | 58.0 | 13.0 | 276.0 | 15.0 |
| 336323 | 10928592 | JA154782 | 01/01/2012 12:00:00 AM | 0000X E 118TH PL | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | True | True | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 336324 | 9467940 | HX120966 | 01/01/2012 12:00:00 AM | 015XX S KEELER AVE | 0840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | ... | (41.860113198, -87.729881467) | 36.0 | 21569.0 | 30.0 | 761.0 | 14.0 | 57.0 | 21.0 | 109.0 | 24.0 |
336325 rows × 31 columns
Chicago = Chicago.dropna()
Chicago_theft_sample = Chicago.sample(frac=1, random_state=42)
Chicago_theft_data = Chicago_theft_sample[Chicago_theft_sample["Primary Type"] == "THEFT"]
Chicago_theft_data
| ID | Case Number | Date | Block | IUCR | Primary Type | Description | Location Description | Arrest | Domestic | ... | Location | Historical Wards 2003-2015 | Zip Codes | Community Areas | Census Tracts | Wards | Boundaries - ZIP Codes | Police Districts | Police Beats | Wards 2023- | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22474 | 8921124 | HV592953 | 12/03/2012 10:00:00 PM | 026XX W 35TH PL | 0840 | THEFT | FINANCIAL ID THEFT: OVER $300 | OTHER | False | False | ... | (41.829258146, -87.690690891) | 29.0 | 22248.0 | 55.0 | 638.0 | 1.0 | 56.0 | 23.0 | 96.0 | 12.0 |
| 155202 | 8706239 | HV382465 | 07/14/2012 01:30:00 AM | 052XX S MICHIGAN AVE | 0890 | THEFT | FROM BUILDING | OTHER | False | False | ... | (41.799858243, -87.622596769) | 12.0 | 21192.0 | 7.0 | 218.0 | 9.0 | 10.0 | 24.0 | 111.0 | 8.0 |
| 192972 | 8648938 | HV324042 | 06/08/2012 04:15:00 AM | 003XX N LA SALLE DR | 0870 | THEFT | POCKET-PICKING | STREET | True | False | ... | (41.888599915, -87.632510468) | 22.0 | 4446.0 | 37.0 | 670.0 | 36.0 | 55.0 | 14.0 | 73.0 | 42.0 |
| 219443 | 8609272 | HV282904 | 05/12/2012 02:00:00 AM | 019XX W DIVERSEY PKWY | 0820 | THEFT | $500 AND UNDER | STREET | False | False | ... | (41.932306289, -87.676441918) | 16.0 | 21190.0 | 68.0 | 649.0 | 40.0 | 16.0 | 5.0 | 172.0 | 32.0 |
| 87969 | 8813861 | HV487221 | 09/21/2012 12:00:00 PM | 007XX S CLAREMONT AVE | 0820 | THEFT | $500 AND UNDER | STREET | False | False | ... | (41.872184627, -87.684966578) | 48.0 | 21184.0 | 29.0 | 757.0 | 23.0 | 28.0 | 15.0 | 139.0 | 28.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 264876 | 8535449 | HV212046 | 03/23/2012 08:30:00 PM | 001XX W HUBBARD ST | 0890 | THEFT | FROM BUILDING | RESTAURANT | False | False | ... | (41.890013524, -87.631664996) | 22.0 | 4446.0 | 37.0 | 670.0 | 36.0 | 55.0 | 14.0 | 73.0 | 42.0 |
| 65276 | 8862096 | HV535499 | 10/16/2012 04:00:00 PM | 027XX E 89TH ST | 0820 | THEFT | $500 AND UNDER | SCHOOL, PUBLIC, BUILDING | False | False | ... | (41.73365047, -87.557845321) | 43.0 | 21202.0 | 42.0 | 508.0 | 37.0 | 25.0 | 19.0 | 238.0 | 5.0 |
| 280207 | 8510397 | HV187643 | 03/07/2012 07:30:00 PM | 054XX N CUMBERLAND AVE | 0890 | THEFT | FROM BUILDING | OTHER | False | False | ... | (41.97855782, -87.836588785) | 34.0 | 4448.0 | 36.0 | 735.0 | 29.0 | 31.0 | 12.0 | 44.0 | 41.0 |
| 192808 | 8650043 | HV324578 | 06/08/2012 09:30:00 AM | 024XX W ROOSEVELT RD | 0820 | THEFT | $500 AND UNDER | GAS STATION | False | False | ... | (41.866604054, -87.686645691) | 11.0 | 14920.0 | 29.0 | 96.0 | 23.0 | 43.0 | 21.0 | 151.0 | 28.0 |
| 55272 | 8864755 | HV538265 | 10/27/2012 12:00:00 PM | 013XX N STATE PKWY | 0890 | THEFT | FROM BUILDING | HOTEL/MOTEL | False | False | ... | (41.906054951, -87.628752556) | 22.0 | 14926.0 | 37.0 | 17.0 | 11.0 | 54.0 | 14.0 | 197.0 | 2.0 |
74683 rows × 31 columns
theft_counts_by_area = Chicago_theft_data.groupby('Community Area').size().reset_index()
theft_counts_by_area.columns = ['Community Area', 'Theft Count']
print(theft_counts_by_area)
Community Area Theft Count 0 1.0 959 1 2.0 963 2 3.0 1340 3 4.0 691 4 5.0 679 .. ... ... 72 73.0 738 73 74.0 193 74 75.0 636 75 76.0 542 76 77.0 994 [77 rows x 2 columns]
df =pd.DataFrame(Chicago_theft_data)
print (df)
ID Case Number Date Block \
22474 8921124 HV592953 12/03/2012 10:00:00 PM 026XX W 35TH PL
155202 8706239 HV382465 07/14/2012 01:30:00 AM 052XX S MICHIGAN AVE
192972 8648938 HV324042 06/08/2012 04:15:00 AM 003XX N LA SALLE DR
219443 8609272 HV282904 05/12/2012 02:00:00 AM 019XX W DIVERSEY PKWY
87969 8813861 HV487221 09/21/2012 12:00:00 PM 007XX S CLAREMONT AVE
... ... ... ... ...
264876 8535449 HV212046 03/23/2012 08:30:00 PM 001XX W HUBBARD ST
65276 8862096 HV535499 10/16/2012 04:00:00 PM 027XX E 89TH ST
280207 8510397 HV187643 03/07/2012 07:30:00 PM 054XX N CUMBERLAND AVE
192808 8650043 HV324578 06/08/2012 09:30:00 AM 024XX W ROOSEVELT RD
55272 8864755 HV538265 10/27/2012 12:00:00 PM 013XX N STATE PKWY
IUCR Primary Type Description \
22474 0840 THEFT FINANCIAL ID THEFT: OVER $300
155202 0890 THEFT FROM BUILDING
192972 0870 THEFT POCKET-PICKING
219443 0820 THEFT $500 AND UNDER
87969 0820 THEFT $500 AND UNDER
... ... ... ...
264876 0890 THEFT FROM BUILDING
65276 0820 THEFT $500 AND UNDER
280207 0890 THEFT FROM BUILDING
192808 0820 THEFT $500 AND UNDER
55272 0890 THEFT FROM BUILDING
Location Description Arrest Domestic ... \
22474 OTHER False False ...
155202 OTHER False False ...
192972 STREET True False ...
219443 STREET False False ...
87969 STREET False False ...
... ... ... ... ...
264876 RESTAURANT False False ...
65276 SCHOOL, PUBLIC, BUILDING False False ...
280207 OTHER False False ...
192808 GAS STATION False False ...
55272 HOTEL/MOTEL False False ...
Location Historical Wards 2003-2015 Zip Codes \
22474 (41.829258146, -87.690690891) 29.0 22248.0
155202 (41.799858243, -87.622596769) 12.0 21192.0
192972 (41.888599915, -87.632510468) 22.0 4446.0
219443 (41.932306289, -87.676441918) 16.0 21190.0
87969 (41.872184627, -87.684966578) 48.0 21184.0
... ... ... ...
264876 (41.890013524, -87.631664996) 22.0 4446.0
65276 (41.73365047, -87.557845321) 43.0 21202.0
280207 (41.97855782, -87.836588785) 34.0 4448.0
192808 (41.866604054, -87.686645691) 11.0 14920.0
55272 (41.906054951, -87.628752556) 22.0 14926.0
Community Areas Census Tracts Wards Boundaries - ZIP Codes \
22474 55.0 638.0 1.0 56.0
155202 7.0 218.0 9.0 10.0
192972 37.0 670.0 36.0 55.0
219443 68.0 649.0 40.0 16.0
87969 29.0 757.0 23.0 28.0
... ... ... ... ...
264876 37.0 670.0 36.0 55.0
65276 42.0 508.0 37.0 25.0
280207 36.0 735.0 29.0 31.0
192808 29.0 96.0 23.0 43.0
55272 37.0 17.0 11.0 54.0
Police Districts Police Beats Wards 2023-
22474 23.0 96.0 12.0
155202 24.0 111.0 8.0
192972 14.0 73.0 42.0
219443 5.0 172.0 32.0
87969 15.0 139.0 28.0
... ... ... ...
264876 14.0 73.0 42.0
65276 19.0 238.0 5.0
280207 12.0 44.0 41.0
192808 21.0 151.0 28.0
55272 14.0 197.0 2.0
[74683 rows x 31 columns]
ChicagoGeo = "https://gist.githubusercontent.com/juliasharkowicz/b0c20ccfc65a46bf1881657d35161b41/raw/32eb6f20c1aa98ce137b607fb598c9a7dd16eac0/gistfile1.txt"
geodata_chicago = alt.Data(url=ChicagoGeo, format=alt.DataFormat(property="features", type="json"))
chicago_land = alt.Chart(geodata_chicago).mark_geoshape(
stroke='white',
fill='lightgray'
).properties(
width=800, # Set the width to make the map wider
height=600 # You can adjust the height as needed
)
chicago_land
import altair as alt
import pandas as pd
Chicago1 = Chicago.head(5000)
Chicago2 = alt.Chart(Chicago1).mark_circle(opacity=0.4).encode(
longitude =('Long:Q'),
latitude = ('Lat:Q'),
tooltip=['Long:Q', 'Lat:Q', 'Primary Type', 'Community Area'],
color=alt.Color('Primary Type:N', scale=alt.Scale(scheme='magma') ) # Set color scheme to 'viridis'
).project(type ='albersUsa')
chicago_land + Chicago2
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
Chicago_theft_map = Chicago_theft_data.head(10000)
# Now, you can use this filtered dataframe to create your chart
Chicago3 = alt.Chart(Chicago_theft_map).mark_circle(opacity=0.2).encode(
longitude=('Longitude:Q'),
latitude=('Latitude:Q'),
tooltip=['Longitude:Q', 'Latitude:Q', 'Primary Type','Community Area'],
color=alt.Color('Primary Type:N', scale=alt.Scale(scheme='tableau10'))
).project(
type='albersUsa'
)
# Assuming you've already defined chicago_land somewhere
chicago_land + Chicago3
# merged the data sets using geodatamerger (merged the crime CSV with a CSV for socioeconomic factors)
# merged on "Community Area Number"and "community areas"
# https://drive.google.com/file/d/1c4_78Np5-DGePRzUGVLGrSluBoB2qo1l/view?usp=sharing
socioeconomicMerge = pd.read_csv("https://drive.google.com/uc?id=1c4_78Np5-DGePRzUGVLGrSluBoB2qo1l")
socioeconomicMerge
Chicago[['Latitude', 'Longitude']] = Chicago['Location'].str.extract(r'\((.*), (.*)\)')
Chicago['Latitude'] = pd.to_numeric(Chicago['Latitude'], errors='coerce')
Chicago['Longitude'] = pd.to_numeric(Chicago['Longitude'], errors='coerce')
import pandas as pd
pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)
/tmp/ipykernel_303/3919695009.py:7: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy Chicago[['Latitude', 'Longitude']] = Chicago['Location'].str.extract(r'\((.*), (.*)\)') /tmp/ipykernel_303/3919695009.py:9: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy Chicago['Latitude'] = pd.to_numeric(Chicago['Latitude'], errors='coerce') /tmp/ipykernel_303/3919695009.py:10: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy Chicago['Longitude'] = pd.to_numeric(Chicago['Longitude'], errors='coerce')
# calculates the percentage of crimes that are theft in each community area
grouped = Chicago.groupby('Community Area').apply(lambda x: (x['Primary Type'] == 'THEFT').sum() / len(x) * 100).reset_index()
grouped.columns = ['Community Area Number', 'Theft Percentage']
# Merge the theft percentage with your existing dataframe
socioeconomicMerge = socioeconomicMerge.merge(grouped, on='Community Area Number', how='left')
socioeconomicMerge
| Community Area Number | COMMUNITY AREA NAME | PERCENT OF HOUSING CROWDED | PERCENT HOUSEHOLDS BELOW POVERTY | PERCENT AGED 16+ UNEMPLOYED | PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA | PERCENT AGED UNDER 18 OR OVER 64 | PER CAPITA INCOME | HARDSHIP INDEX | ID | Case Number | Date | Block | IUCR | Primary Type | Description | Location Description | Arrest | Domestic | Beat | District | Ward | Community Area | FBI Code | X Coordinate | Y Coordinate | Year | Updated On | Latitude | Longitude | Location | Historical Wards 2003-2015 | Zip Codes | Community Areas | Census Tracts | Wards | Boundaries - ZIP Codes | Police Districts | Police Beats | Wards 2023- | Theft Percentage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | Rogers Park | 7.7 | 23.6 | 8.7 | 18.2 | 27.5 | 23939 | 39.0 | 8522872 | HV199799 | 01/01/2012 12:01:00 AM | 068XX N SHERIDAN RD | 890 | THEFT | FROM BUILDING | RESIDENCE | False | False | 2431 | 24 | 49 | 1.0 | 06 | 1166981.0 | 1945453.0 | 2012 | 02/04/2016 06:33:39 AM | 42.005888 | -87.661005 | (42.005887804, -87.661005031) | 3.0 | 21853.0 | 10.0 | 267.0 | 5.0 | 9.0 | 11.0 | 39.0 | 49.0 | 20.071159 |
| 1 | 2.0 | West Ridge | 7.8 | 17.2 | 8.8 | 20.8 | 38.5 | 23040 | 46.0 | 8481432 | HV158191 | 01/01/2012 12:00:00 AM | 066XX N SEELEY AVE | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | RESIDENCE | False | False | 2412 | 24 | 50 | 2.0 | 02 | 1161424.0 | 1944172.0 | 2012 | 02/10/2018 03:50:01 PM | 42.002491 | -87.681486 | (42.002490631, -87.681485671) | 42.0 | 22528.0 | 20.0 | 320.0 | 27.0 | 12.0 | 11.0 | 46.0 | 40.0 | 24.220322 |
| 2 | 3.0 | Uptown | 3.8 | 24.0 | 8.9 | 11.8 | 22.2 | 35787 | 20.0 | 9786892 | HX434641 | 01/01/2012 12:00:00 AM | 008XX W EASTWOOD AVE | 266 | CRIM SEXUAL ASSAULT | PREDATORY | RESIDENCE | False | True | 1914 | 19 | 46 | 3.0 | 02 | 1169806.0 | 1931096.0 | 2012 | 02/10/2018 03:50:01 PM | 41.966431 | -87.651032 | (41.966430564, -87.651032417) | 37.0 | 22616.0 | 31.0 | 19.0 | 39.0 | 15.0 | 5.0 | 4.0 | 46.0 | 27.005240 |
| 3 | 4.0 | Lincoln Square | 3.4 | 10.9 | 8.2 | 13.4 | 25.5 | 37524 | 17.0 | 8639260 | HV313362 | 01/01/2012 12:01:00 AM | 048XX N CLAREMONT AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 2031 | 20 | 47 | 4.0 | 06 | 1159822.0 | 1932094.0 | 2012 | 02/04/2016 06:33:39 AM | 41.969381 | -87.687714 | (41.969381427, -87.687714236) | 13.0 | 21849.0 | 6.0 | 54.0 | 18.0 | 20.0 | 2.0 | 61.0 | 47.0 | 29.720430 |
| 4 | 5.0 | North Center | 0.3 | 7.5 | 5.2 | 4.5 | 26.2 | 57123 | 6.0 | 8719401 | HV387013 | 01/01/2012 12:00:00 AM | 040XX N HOYNE AVE | 1563 | SEX OFFENSE | CRIMINAL SEXUAL ABUSE | RESIDENCE | False | False | 1911 | 19 | 47 | 5.0 | 17 | 1161635.0 | 1926718.0 | 2012 | 02/04/2016 06:33:39 AM | 41.954592 | -87.681198 | (41.954591739, -87.681198274) | 13.0 | 21538.0 | 46.0 | 623.0 | 18.0 | 39.0 | 5.0 | 10.0 | 47.0 | 35.475444 |
| 5 | 6.0 | Lake View | 1.1 | 11.4 | 4.7 | 2.6 | 17.0 | 60058 | 5.0 | 8856125 | HV529988 | 01/01/2012 12:00:00 AM | 006XX W CORNELIA AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1925 | 19 | 46 | 6.0 | 06 | 1171080.0 | 1923465.0 | 2012 | 02/10/2018 03:50:01 PM | 41.945463 | -87.646573 | (41.945462922, -87.646573015) | 38.0 | 4449.0 | 57.0 | 730.0 | 25.0 | 22.0 | 5.0 | 18.0 | 44.0 | 37.566967 |
| 6 | 7.0 | Lincoln Park | 0.8 | 12.3 | 5.1 | 3.6 | 21.5 | 71551 | 2.0 | 8424740 | HV103697 | 01/01/2012 12:00:00 AM | 014XX W FULLERTON AVE | 460 | BATTERY | SIMPLE | APARTMENT | False | False | 1931 | 19 | 32 | 7.0 | 08B | 1166102.0 | 1916039.0 | 2012 | 02/10/2018 03:50:01 PM | 41.925194 | -87.665083 | (41.925193578, -87.66508297) | 16.0 | 21190.0 | 68.0 | 770.0 | 11.0 | 16.0 | 5.0 | 173.0 | 32.0 | 44.323671 |
| 7 | 8.0 | Near North Side | 1.9 | 12.9 | 7.0 | 2.5 | 22.6 | 88669 | 1.0 | 8904856 | HV578917 | 01/01/2012 12:00:00 AM | 002XX E CHESTNUT ST | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1833 | 18 | 42 | 8.0 | 06 | 1178637.0 | 1906397.0 | 2012 | 02/10/2018 03:50:01 PM | 41.898458 | -87.619319 | (41.898458275, -87.619318967) | 22.0 | 21182.0 | 37.0 | 233.0 | 11.0 | 6.0 | 14.0 | 71.0 | 2.0 | 48.858488 |
| 8 | 9.0 | Edison Park | 1.1 | 3.3 | 6.5 | 7.4 | 35.3 | 40959 | 8.0 | 9274751 | HW419186 | 01/01/2012 12:00:00 AM | 073XX N ORIOLE AVE | 2825 | OTHER OFFENSE | HARASSMENT BY TELEPHONE | RESIDENCE | False | False | 1611 | 16 | 41 | 9.0 | 26 | 1124738.0 | 1948147.0 | 2012 | 02/10/2018 03:50:01 PM | 42.014085 | -87.816364 | (42.014085475, -87.81636423) | 34.0 | 22243.0 | 77.0 | 653.0 | 29.0 | 17.0 | 12.0 | 34.0 | 41.0 | 22.442244 |
| 9 | 10.0 | Norwood Park | 2.0 | 5.4 | 9.0 | 11.5 | 39.5 | 32875 | 21.0 | 9055356 | HW199594 | 01/01/2012 12:00:00 AM | 057XX N WEST CIRCLE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | STREET | False | False | 1612 | 16 | 41 | 10.0 | 06 | 1127968.0 | 1937874.0 | 2012 | 02/10/2018 03:50:01 PM | 41.985841 | -87.804712 | (41.985841282, -87.8047123) | 34.0 | 22243.0 | 36.0 | 733.0 | 29.0 | 17.0 | 12.0 | 45.0 | 41.0 | 28.156028 |
| 10 | 11.0 | Jefferson Park | 2.7 | 8.6 | 12.4 | 13.4 | 35.5 | 27751 | 25.0 | 11865218 | JC471748 | 01/01/2012 12:00:00 AM | 062XX W FOSTER AVE | 1750 | OFFENSE INVOLVING CHILDREN | CHILD ABUSE | CHURCH/SYNAGOGUE/PLACE OF WORSHIP | False | True | 1622 | 16 | 45 | 11.0 | 08B | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25.854701 |
| 11 | 12.0 | Forest Glen | 1.1 | 7.5 | 6.8 | 4.9 | 40.5 | 44164 | 11.0 | 8548806 | HV224880 | 01/01/2012 12:01:00 AM | 062XX N KEYSTONE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | STREET | False | False | 1711 | 17 | 39 | 12.0 | 06 | 1148230.0 | 1941153.0 | 2012 | 02/04/2016 06:33:39 AM | 41.994472 | -87.730104 | (41.9944717, -87.730103763) | 28.0 | 22532.0 | 12.0 | 713.0 | 38.0 | 18.0 | 1.0 | 53.0 | 39.0 | 30.292599 |
| 12 | 13.0 | North Park | 3.9 | 13.2 | 9.9 | 14.4 | 39.0 | 26576 | 33.0 | 8679089 | HV354082 | 01/01/2012 12:01:00 AM | 040XX W PETERSON AVE | 2820 | OTHER OFFENSE | TELEPHONE THREAT | MEDICAL/DENTAL OFFICE | False | False | 1711 | 17 | 39 | 13.0 | 26 | 1148144.0 | 1939564.0 | 2012 | 02/04/2016 06:33:39 AM | 41.990113 | -87.730461 | (41.990113051, -87.730461261) | 28.0 | 22532.0 | 13.0 | 748.0 | 38.0 | 18.0 | 1.0 | 53.0 | 39.0 | 30.252101 |
| 13 | 14.0 | Albany Park | 11.3 | 19.2 | 10.0 | 32.9 | 32.0 | 21323 | 53.0 | 8519160 | HV194208 | 01/01/2012 12:00:00 AM | 047XX N HARDING AVE | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | False | 1723 | 17 | 39 | 14.0 | 17 | 1149205.0 | 1931162.0 | 2012 | 02/04/2016 06:33:39 AM | 41.967037 | -87.726777 | (41.96703686, -87.726777496) | 28.0 | 21849.0 | 14.0 | 117.0 | 12.0 | 20.0 | 1.0 | 9.0 | 33.0 | 20.816327 |
| 14 | 15.0 | Portage Park | 4.1 | 11.6 | 12.6 | 19.3 | 34.0 | 24336 | 35.0 | 8460773 | HV138026 | 01/01/2012 12:00:00 AM | 050XX W WARWICK AVE | 1563 | SEX OFFENSE | CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 1634 | 16 | 45 | 15.0 | 17 | 1142107.0 | 1924463.0 | 2012 | 09/07/2021 03:41:02 PM | 41.948789 | -87.753043 | (41.948789141, -87.753043017) | 20.0 | 22618.0 | 15.0 | 360.0 | 50.0 | 21.0 | 12.0 | 26.0 | 30.0 | 25.741142 |
| 15 | 16.0 | Irving Park | 6.3 | 13.1 | 10.0 | 22.4 | 31.6 | 27249 | 34.0 | 8612446 | HV286559 | 01/01/2012 12:01:00 AM | 032XX N KILDARE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1731 | 17 | 31 | 16.0 | 06 | 1147143.0 | 1921400.0 | 2012 | 02/04/2016 06:33:39 AM | 41.940289 | -87.734610 | (41.940288955, -87.734610033) | 7.0 | 22618.0 | 16.0 | 328.0 | 21.0 | 21.0 | 1.0 | 25.0 | 30.0 | 21.792261 |
| 16 | 17.0 | Dunning | 5.2 | 10.6 | 10.0 | 16.2 | 33.6 | 26282 | 28.0 | 8630608 | HV304221 | 01/01/2012 12:00:00 AM | 065XX W BYRON ST | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 1632 | 16 | 38 | 17.0 | 17 | 1132230.0 | 1925250.0 | 2012 | 02/04/2016 06:33:39 AM | 41.951127 | -87.789331 | (41.951126516, -87.789331374) | 25.0 | 22254.0 | 17.0 | 444.0 | 19.0 | 52.0 | 12.0 | 17.0 | 38.0 | 23.402007 |
| 17 | 18.0 | Montclaire | 8.1 | 15.3 | 13.8 | 23.5 | 38.6 | 22014 | 50.0 | 13184630 | JG330270 | 01/01/2012 12:00:00 AM | 070XX W DIVERSEY AVE | 1754 | OFFENSE INVOLVING CHILDREN | AGGRAVATED SEXUAL ASSAULT OF CHILD BY FAMILY M... | APARTMENT | False | True | 2511 | 25 | 29 | 18.0 | 02 | NaN | NaN | 2012 | 08/23/2023 03:41:55 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 20.079787 |
| 18 | 19.0 | Belmont Cragin | 10.8 | 18.7 | 14.6 | 37.3 | 37.3 | 15461 | 70.0 | 10433096 | HZ170962 | 01/01/2012 12:00:00 AM | 026XX N MC VICKER AVE | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | True | True | 2512 | 25 | 29 | 19.0 | 17 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 19.055862 |
| 19 | 20.0 | Hermosa | 6.9 | 20.5 | 13.1 | 41.6 | 36.4 | 15089 | 71.0 | 11002368 | JA329407 | 01/01/2012 12:00:00 AM | 021XX N KENNETH AVE | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | False | True | 2522 | 25 | 31 | 20.0 | 20 | NaN | NaN | 2012 | 11/27/2017 03:53:35 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.113281 |
| 20 | 21.0 | Avondale | 6.0 | 15.3 | 9.2 | 24.7 | 31.0 | 20039 | 42.0 | 9485925 | HX138962 | 01/01/2012 12:00:00 AM | 033XX N KEDZIE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | OTHER | False | False | 1733 | 17 | 33 | 21.0 | 06 | 1154463.0 | 1921987.0 | 2012 | 02/04/2016 06:33:39 AM | 41.941756 | -87.707691 | (41.941756281, -87.70769069) | 15.0 | 21538.0 | 22.0 | 138.0 | 12.0 | 39.0 | 1.0 | 23.0 | 35.0 | 21.376147 |
| 21 | 22.0 | Logan Square | 3.2 | 16.8 | 8.2 | 14.8 | 26.2 | 31908 | 23.0 | 8580117 | HV254276 | 01/01/2012 12:00:00 AM | 037XX W LYNDALE ST | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | True | 2525 | 25 | 35 | 22.0 | 20 | 1151032.0 | 1914695.0 | 2012 | 02/04/2016 06:33:39 AM | 41.921814 | -87.720493 | (41.921814446, -87.720492698) | 15.0 | 22535.0 | 23.0 | 74.0 | 12.0 | 1.0 | 6.0 | 187.0 | 35.0 | 28.799527 |
| 22 | 23.0 | Humboldt park | 14.8 | 33.9 | 17.3 | 35.4 | 38.0 | 13781 | 85.0 | 10440733 | HZ179414 | 01/01/2012 12:00:00 AM | 038XX W OHIO ST | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | APARTMENT | False | False | 1122 | 11 | 27 | 23.0 | 11 | NaN | NaN | 2012 | 03/09/2016 04:05:56 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14.008582 |
| 23 | 24.0 | West Town | 2.3 | 14.7 | 6.6 | 12.9 | 21.7 | 43198 | 10.0 | 8647985 | HV322951 | 01/01/2012 12:00:00 AM | 015XX N CAMPBELL AVE | 1305 | CRIMINAL DAMAGE | CRIMINAL DEFACEMENT | RESIDENCE-GARAGE | False | False | 1423 | 14 | 1 | 24.0 | 14 | 1159459.0 | 1910195.0 | 2012 | 02/04/2016 06:33:39 AM | 41.909297 | -87.689654 | (41.909296674, -87.689653613) | 10.0 | 21560.0 | 25.0 | 302.0 | 41.0 | 4.0 | 7.0 | 62.0 | 1.0 | 32.515020 |
| 24 | 25.0 | Austin | 6.3 | 28.6 | 22.6 | 24.4 | 37.9 | 15957 | 73.0 | 10401057 | HZ137709 | 01/01/2012 12:00:00 AM | 050XX W HURON ST | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 1532 | 15 | 28 | 25.0 | 17 | NaN | NaN | 2012 | 02/11/2016 03:47:22 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 15.036232 |
| 25 | 26.0 | West Garfield Park | 9.4 | 41.7 | 25.8 | 24.5 | 43.6 | 10934 | 92.0 | 8421939 | HV100656 | 01/01/2012 12:00:00 AM | 044XX W WEST END AVE | 890 | THEFT | FROM BUILDING | RESIDENCE | False | False | 1113 | 11 | 28 | 26.0 | 06 | 1146850.0 | 1900608.0 | 2012 | 02/04/2016 06:33:39 AM | 41.883239 | -87.736219 | (41.883239213, -87.73621892) | 11.0 | 21572.0 | 27.0 | 732.0 | 23.0 | 30.0 | 16.0 | 90.0 | 28.0 | 12.610586 |
| 26 | 27.0 | East Garfield Park | 8.2 | 42.4 | 19.6 | 21.3 | 43.2 | 12961 | 83.0 | 9087981 | HW232769 | 01/01/2012 12:00:00 AM | 008XX S INDEPENDENCE BLVD | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 1133 | 11 | 24 | 27.0 | 06 | 1151390.0 | 1896019.0 | 2012 | 02/10/2018 03:50:01 PM | 41.870559 | -87.719668 | (41.870558601, -87.719668116) | 36.0 | 21572.0 | 28.0 | 704.0 | 14.0 | 30.0 | 16.0 | 141.0 | 24.0 | 13.619433 |
| 27 | 28.0 | Near West Side | 3.8 | 20.6 | 10.7 | 9.6 | 22.2 | 44689 | 15.0 | 8678186 | HV352296 | 01/01/2012 12:00:00 AM | 013XX W WASHBURNE AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | False | 1231 | 12 | 2 | 28.0 | 20 | 1167691.0 | 1894516.0 | 2012 | 02/04/2016 06:33:39 AM | 41.866099 | -87.659865 | (41.866098868, -87.659865054) | 48.0 | 14920.0 | 29.0 | 96.0 | 26.0 | 43.0 | 15.0 | 150.0 | 28.0 | 35.867363 |
| 28 | 29.0 | North Lawndale | 7.4 | 43.1 | 21.2 | 27.6 | 42.7 | 12034 | 87.0 | 9467940 | HX120966 | 01/01/2012 12:00:00 AM | 015XX S KEELER AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1012 | 10 | 24 | 29.0 | 06 | 1148635.0 | 1892193.0 | 2012 | 02/10/2018 03:50:01 PM | 41.860113 | -87.729881 | (41.860113198, -87.729881467) | 36.0 | 21569.0 | 30.0 | 761.0 | 14.0 | 57.0 | 21.0 | 109.0 | 24.0 | 13.414282 |
| 29 | 30.0 | South Lawndale | 15.2 | 30.7 | 15.8 | 54.8 | 33.8 | 10402 | 96.0 | 11861733 | JC473689 | 01/01/2012 12:00:00 AM | 022XX S CALIFORNIA AVE | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | RESIDENCE | False | True | 1033 | 10 | 12 | 30.0 | 02 | NaN | NaN | 2012 | 10/16/2019 09:37:36 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.730236 |
| 30 | 31.0 | Lower West Side | 9.6 | 25.8 | 15.8 | 40.7 | 32.6 | 16444 | 76.0 | 8538123 | HV214939 | 01/01/2012 12:01:00 AM | 021XX W 18TH ST | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | RESIDENCE | False | False | 1223 | 12 | 25 | 31.0 | 02 | 1162499.0 | 1891389.0 | 2012 | 02/04/2016 06:33:39 AM | 41.857628 | -87.679013 | (41.857628272, -87.679012753) | 8.0 | 14920.0 | 33.0 | 4.0 | 26.0 | 43.0 | 15.0 | 121.0 | 25.0 | 20.408163 |
| 31 | 32.0 | Loop | 1.5 | 14.7 | 5.7 | 3.1 | 13.5 | 65526 | 3.0 | 11655969 | JC225381 | 01/01/2012 12:00:00 AM | 001XX W RANDOLPH ST | 486 | BATTERY | DOMESTIC BATTERY SIMPLE | RESIDENCE | False | True | 122 | 1 | 42 | 32.0 | 08B | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 53.431563 |
| 32 | 33.0 | Near South Side | 1.3 | 13.8 | 4.9 | 7.4 | 21.8 | 59077 | 7.0 | 8812790 | HV485714 | 01/01/2012 12:01:00 AM | 022XX S WABASH AVE | 1150 | DECEPTIVE PRACTICE | CREDIT CARD FRAUD | OTHER | False | False | 131 | 1 | 2 | 33.0 | 11 | 1177098.0 | 1889498.0 | 2012 | 02/10/2018 03:50:01 PM | 41.852121 | -87.625483 | (41.852121445, -87.625483421) | 48.0 | 21194.0 | 34.0 | 193.0 | 9.0 | 40.0 | 22.0 | 94.0 | 8.0 | 39.086022 |
| 33 | 34.0 | Armour Square | 5.7 | 40.1 | 16.7 | 34.5 | 38.3 | 16148 | 82.0 | 8421660 | HV100180 | 01/01/2012 01:20:00 AM | 002XX W 26TH ST | 430 | BATTERY | AGGRAVATED: OTHER DANG WEAPON | PARKING LOT/GARAGE(NON.RESID.) | True | False | 914 | 9 | 11 | 34.0 | 04B | 1174834.0 | 1887065.0 | 2012 | 02/10/2018 03:50:01 PM | 41.845496 | -87.633866 | (41.84549602, -87.633865582) | 26.0 | 21194.0 | 35.0 | 346.0 | 48.0 | 40.0 | 23.0 | 157.0 | 7.0 | 27.890268 |
| 34 | 35.0 | Douglas | 1.8 | 29.6 | 18.2 | 14.3 | 30.7 | 23791 | 47.0 | 10532867 | HZ276514 | 01/01/2012 12:00:00 AM | 036XX S RHODES AVE | 1563 | SEX OFFENSE | CRIMINAL SEXUAL ABUSE | APARTMENT | False | True | 212 | 2 | 4 | 35.0 | 17 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 24.791893 |
| 35 | 36.0 | Oakland | 1.3 | 39.7 | 28.7 | 18.4 | 40.4 | 19252 | 78.0 | 8421472 | HV100138 | 01/01/2012 01:38:00 AM | 042XX S DREXEL BLVD | 486 | BATTERY | DOMESTIC BATTERY SIMPLE | APARTMENT | False | True | 2123 | 2 | 4 | 36.0 | 08B | 1182889.0 | 1876982.0 | 2012 | 02/10/2018 03:50:01 PM | 41.817644 | -87.604619 | (41.817643766, -87.604618853) | 1.0 | 4301.0 | 2.0 | 220.0 | 10.0 | 36.0 | 24.0 | 104.0 | 9.0 | 20.984456 |
| 36 | 37.0 | Fuller Park | 3.2 | 51.2 | 33.9 | 26.6 | 44.9 | 10432 | 97.0 | 9836248 | HX484599 | 01/01/2012 12:00:00 AM | 001XX W GARFIELD BLVD | 1130 | DECEPTIVE PRACTICE | FRAUD OR CONFIDENCE GAME | CURRENCY EXCHANGE | True | False | 225 | 2 | 3 | 37.0 | 11 | 1176228.0 | 1868523.0 | 2012 | 02/10/2018 03:50:01 PM | 41.794584 | -87.629307 | (41.794583892, -87.629307346) | 12.0 | 21559.0 | 66.0 | 166.0 | 9.0 | 37.0 | 24.0 | 111.0 | 20.0 | 20.540098 |
| 37 | 38.0 | Grand Boulevard | 3.3 | 29.3 | 24.3 | 15.9 | 39.5 | 23472 | 57.0 | 8424419 | HV102059 | 01/01/2012 03:00:00 AM | 046XX S PRAIRIE AVE | 281 | CRIM SEXUAL ASSAULT | NON-AGGRAVATED | RESIDENCE | False | False | 221 | 2 | 3 | 38.0 | 02 | 1178818.0 | 1874416.0 | 2012 | 02/10/2018 03:50:01 PM | 41.810696 | -87.619631 | (41.810696214, -87.619630513) | 12.0 | 4301.0 | 4.0 | 354.0 | 9.0 | 36.0 | 24.0 | 98.0 | 8.0 | 17.389187 |
| 38 | 39.0 | Kenwood | 2.4 | 21.7 | 15.7 | 11.3 | 35.4 | 35911 | 26.0 | 8916155 | HV588860 | 01/01/2012 12:00:00 AM | 050XX S LAKE SHORE DR W | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | APARTMENT | False | False | 222 | 2 | 4 | 39.0 | 06 | 1188639.0 | 1871868.0 | 2012 | 02/10/2018 03:50:01 PM | 41.803475 | -87.583690 | (41.803474876, -87.583690122) | 1.0 | 21192.0 | 5.0 | 400.0 | 33.0 | 10.0 | 24.0 | 113.0 | 3.0 | 28.459821 |
| 39 | 40.0 | Washington Park | 5.6 | 42.1 | 28.6 | 25.4 | 42.8 | 13785 | 88.0 | 11571926 | JC122968 | 01/01/2012 12:00:00 AM | 059XX S INDIANA AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | APARTMENT | True | True | 232 | 2 | 20 | 40.0 | 17 | NaN | NaN | 2012 | 08/01/2019 03:45:33 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14.751732 |
| 40 | 41.0 | Hyde Park | 1.5 | 18.4 | 8.4 | 4.3 | 26.2 | 39056 | 14.0 | 9091480 | HW236506 | 01/01/2012 12:00:00 AM | 055XX S COTTAGE GROVE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 235 | 2 | 5 | 41.0 | 06 | 1182527.0 | 1868455.0 | 2012 | 02/10/2018 03:50:01 PM | 41.794253 | -87.606211 | (41.794253414, -87.606211387) | 32.0 | 22260.0 | 8.0 | 401.0 | 33.0 | 60.0 | 24.0 | 132.0 | 3.0 | 34.500784 |
| 41 | 42.0 | Woodlawn | 2.9 | 30.7 | 23.4 | 16.5 | 36.1 | 18672 | 58.0 | 8821354 | HV494310 | 01/01/2012 12:01:00 AM | 063XX S ST LAWRENCE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | STREET | False | False | 312 | 3 | 20 | 42.0 | 06 | 1181324.0 | 1863129.0 | 2012 | 02/10/2018 03:50:01 PM | 41.779666 | -87.610787 | (41.779666218, -87.61078682) | 53.0 | 22260.0 | 9.0 | 332.0 | 4.0 | 60.0 | 18.0 | 277.0 | 20.0 | 15.501576 |
| 42 | 43.0 | South Shore | 2.8 | 31.1 | 20.0 | 14.0 | 35.7 | 19398 | 55.0 | 9784782 | HX433977 | 01/01/2012 12:00:00 AM | 078XX S JEFFERY BLVD | 265 | CRIM SEXUAL ASSAULT | AGGRAVATED: OTHER | RESIDENCE | False | True | 414 | 4 | 8 | 43.0 | 02 | 1190897.0 | 1853347.0 | 2012 | 09/07/2021 03:41:02 PM | 41.752598 | -87.576007 | (41.752597535, -87.576007285) | 9.0 | 22538.0 | 39.0 | 420.0 | 35.0 | 24.0 | 19.0 | 222.0 | 10.0 | 16.425246 |
| 43 | 44.0 | Chatham | 3.3 | 27.8 | 24.0 | 14.5 | 40.3 | 18881 | 60.0 | 11012707 | JA342665 | 01/01/2012 12:00:00 AM | 081XX S EVANS AVE | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | OTHER | False | False | 631 | 6 | 6 | 44.0 | 11 | NaN | NaN | 2012 | 07/11/2017 03:48:22 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 22.336009 |
| 44 | 45.0 | Avalon Park | 1.4 | 17.2 | 21.1 | 10.6 | 39.3 | 24454 | 41.0 | 8453833 | HV101813 | 01/01/2012 12:01:00 AM | 080XX S WOODLAWN AVE | 1320 | CRIMINAL DAMAGE | TO VEHICLE | STREET | False | False | 411 | 4 | 8 | 45.0 | 14 | 1185609.0 | 1851926.0 | 2012 | 02/10/2018 03:50:01 PM | 41.748824 | -87.595430 | (41.748824266, -87.595429995) | 9.0 | 21546.0 | 41.0 | 133.0 | 35.0 | 61.0 | 19.0 | 224.0 | 10.0 | 25.055432 |
| 45 | 46.0 | South Chicago | 4.7 | 29.8 | 19.7 | 26.6 | 41.1 | 16579 | 75.0 | 8644620 | HV319861 | 01/01/2012 12:00:00 AM | 087XX S ESCANABA AVE | 4651 | OTHER OFFENSE | SEX OFFENDER: FAIL REG NEW ADD | RESIDENCE | True | False | 423 | 4 | 10 | 46.0 | 26 | 1196905.0 | 1847568.0 | 2012 | 02/04/2016 06:33:39 AM | 41.736592 | -87.554183 | (41.736592286, -87.554182677) | 47.0 | 21202.0 | 42.0 | 509.0 | 47.0 | 25.0 | 19.0 | 238.0 | 6.0 | 14.649984 |
| 46 | 47.0 | Burnside | 6.8 | 33.0 | 18.6 | 19.3 | 42.7 | 12515 | 79.0 | 9535590 | HX189319 | 01/01/2012 12:00:00 AM | 092XX S DREXEL AVE | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | APARTMENT | False | False | 413 | 4 | 8 | 47.0 | 11 | 1184166.0 | 1844031.0 | 2012 | 02/10/2018 03:50:01 PM | 41.727193 | -87.600964 | (41.727193361, -87.600963809) | 9.0 | 21546.0 | 43.0 | 472.0 | 35.0 | 61.0 | 19.0 | 246.0 | 10.0 | 17.415730 |
| 47 | 48.0 | Calumet Heights | 2.1 | 11.5 | 20.0 | 11.0 | 44.0 | 28887 | 38.0 | 8421496 | HV100177 | 01/01/2012 02:10:00 AM | 023XX E 91ST ST | 2025 | NARCOTICS | POSS: HALLUCINOGENS | STREET | True | False | 413 | 4 | 7 | 48.0 | 18 | 1193236.0 | 1845085.0 | 2012 | 02/10/2018 03:50:01 PM | 41.729869 | -87.567705 | (41.729869072, -87.56770535) | 43.0 | 21202.0 | 44.0 | 492.0 | 37.0 | 25.0 | 19.0 | 246.0 | 5.0 | 29.205852 |
| 48 | 49.0 | Roseland | 2.5 | 19.8 | 20.3 | 16.9 | 41.2 | 17949 | 52.0 | 8630662 | HV304328 | 01/01/2012 12:00:00 AM | 111XX S PARNELL AVE | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 2233 | 22 | 34 | 49.0 | 17 | 1174621.0 | 1831009.0 | 2012 | 02/04/2016 06:33:39 AM | 41.691677 | -87.636314 | (41.691676649, -87.636314398) | 45.0 | 21861.0 | 45.0 | 486.0 | 22.0 | 19.0 | 9.0 | 258.0 | 21.0 | 15.912117 |
| 49 | 50.0 | Pullman | 1.5 | 21.6 | 22.8 | 13.1 | 38.6 | 20588 | 51.0 | 10579715 | HZ328636 | 01/01/2012 12:00:00 AM | 007XX E 105TH PL | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 512 | 5 | 9 | 50.0 | 17 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.454690 |
| 50 | 51.0 | South Deering | 4.0 | 29.2 | 16.3 | 21.0 | 39.5 | 14685 | 65.0 | 9006102 | HW153435 | 01/01/2012 12:01:00 AM | 097XX S BRENNAN AVE | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 431 | 4 | 7 | 51.0 | 06 | 1193243.0 | 1840695.0 | 2012 | 02/10/2018 03:50:01 PM | 41.717822 | -87.567823 | (41.717822323, -87.567822714) | 43.0 | 21202.0 | 48.0 | 252.0 | 37.0 | 25.0 | 19.0 | 249.0 | 5.0 | 17.918314 |
| 51 | 52.0 | East Side | 6.8 | 19.2 | 12.1 | 31.9 | 42.8 | 17104 | 64.0 | 9130410 | HW275140 | 01/01/2012 12:00:00 AM | 109XX S BUFFALO AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | True | 432 | 4 | 10 | 52.0 | 20 | 1199876.0 | 1833114.0 | 2012 | 09/07/2021 03:41:02 PM | 41.696855 | -87.543784 | (41.696854988, -87.54378378) | 47.0 | 21202.0 | 49.0 | 602.0 | 47.0 | 25.0 | 19.0 | 247.0 | 6.0 | 15.531178 |
| 52 | 53.0 | West Pullman | 3.3 | 25.9 | 19.4 | 20.5 | 42.1 | 16563 | 62.0 | 10928592 | JA154782 | 01/01/2012 12:00:00 AM | 0000X E 118TH PL | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | True | True | 532 | 5 | 9 | 53.0 | 20 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14.940518 |
| 53 | 54.0 | Riverdale | 5.8 | 56.5 | 34.6 | 27.5 | 51.5 | 8201 | 98.0 | 12364874 | JE229312 | 01/01/2012 12:00:00 AM | 131XX S FORRESTVILLE AVE | 1581 | SEX OFFENSE | NON-CONSENSUAL DISSEMINATION OF PRIVATE SEXUAL... | RESIDENCE | False | False | 533 | 5 | 9 | 54.0 | 17 | NaN | NaN | 2012 | 05/14/2021 03:40:44 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11.047619 |
| 54 | 55.0 | Hegewisch | 3.3 | 17.1 | 9.6 | 19.2 | 42.9 | 22677 | 44.0 | 8438703 | HV116214 | 01/01/2012 12:01:00 AM | 134XX S AVENUE M | 2820 | OTHER OFFENSE | TELEPHONE THREAT | RESIDENCE | False | True | 433 | 4 | 10 | 55.0 | 26 | 1201758.0 | 1816513.0 | 2012 | 02/10/2018 03:50:01 PM | 41.651253 | -87.537455 | (41.65125265, -87.537454574) | 47.0 | 22250.0 | 52.0 | 787.0 | 47.0 | 26.0 | 19.0 | 259.0 | 6.0 | 19.376694 |
| 55 | 56.0 | Garfield Ridge | 2.6 | 8.8 | 11.3 | 19.3 | 38.1 | 26353 | 32.0 | 8964421 | HW112128 | 01/01/2012 12:01:00 AM | 044XX S KILPATRICK AVE | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 815 | 8 | 23 | 56.0 | 06 | 1145771.0 | 1874717.0 | 2012 | 02/10/2018 03:50:01 PM | 41.812211 | -87.740837 | (41.812211369, -87.740837061) | 35.0 | 22248.0 | 53.0 | 566.0 | 28.0 | 56.0 | 13.0 | 105.0 | 22.0 | 22.066694 |
| 56 | 57.0 | Archer Heights | 8.5 | 14.1 | 16.5 | 35.9 | 39.2 | 16134 | 67.0 | 8550554 | HV226299 | 01/01/2012 12:01:00 AM | 050XX S KOLIN AVE | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | False | False | 815 | 8 | 23 | 57.0 | 20 | 1148213.0 | 1870883.0 | 2012 | 02/10/2018 03:50:01 PM | 41.801644 | -87.731978 | (41.801643749, -87.731978113) | 35.0 | 22248.0 | 54.0 | 697.0 | 8.0 | 56.0 | 13.0 | 105.0 | 14.0 | 21.171548 |
| 57 | 58.0 | Brighton Park | 14.4 | 23.6 | 13.9 | 45.1 | 39.3 | 13089 | 84.0 | 10774674 | HZ540883 | 01/01/2012 12:01:00 AM | 045XX S TROY ST | 266 | CRIM SEXUAL ASSAULT | PREDATORY | RESIDENCE | False | True | 922 | 9 | 14 | 58.0 | 02 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 15.966123 |
| 58 | 59.0 | McKinley Park | 7.2 | 18.7 | 13.4 | 32.9 | 35.6 | 16954 | 61.0 | 8558693 | HV234189 | 01/01/2012 12:00:00 AM | 037XX S WOLCOTT AVE | 610 | BURGLARY | FORCIBLE ENTRY | RESIDENCE | False | False | 912 | 9 | 11 | 59.0 | 05 | 1164301.0 | 1879957.0 | 2012 | 02/04/2016 06:33:39 AM | 41.826220 | -87.672721 | (41.826219832, -87.67272111) | 26.0 | 14924.0 | 56.0 | 720.0 | 1.0 | 37.0 | 23.0 | 165.0 | 12.0 | 27.761194 |
| 59 | 60.0 | Bridgeport | 4.5 | 18.9 | 13.7 | 22.2 | 31.3 | 22694 | 43.0 | 8697316 | HV373879 | 01/01/2012 12:00:00 AM | 027XX S EMERALD AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | False | 914 | 9 | 11 | 60.0 | 20 | 1171748.0 | 1886502.0 | 2012 | 02/04/2016 06:33:39 AM | 41.844020 | -87.645207 | (41.844019513, -87.645207358) | 26.0 | 21194.0 | 58.0 | 688.0 | 48.0 | 40.0 | 23.0 | 157.0 | 7.0 | 23.706100 |
| 60 | 61.0 | New City | 11.9 | 29.0 | 23.0 | 41.5 | 38.9 | 12765 | 91.0 | 11419858 | JB400896 | 01/01/2012 12:00:00 AM | 047XX S WOOD ST | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | APARTMENT | True | True | 931 | 9 | 15 | 61.0 | 02 | NaN | NaN | 2012 | 01/24/2019 04:13:10 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.715586 |
| 61 | 62.0 | West Elsdon | 11.1 | 15.6 | 16.7 | 37.0 | 37.7 | 15754 | 69.0 | 8509166 | HV186479 | 01/01/2012 12:01:00 AM | 051XX S PULASKI RD | 1305 | CRIMINAL DAMAGE | CRIMINAL DEFACEMENT | DEPARTMENT STORE | True | False | 815 | 8 | 23 | 62.0 | 14 | 1150563.0 | 1870470.0 | 2012 | 02/10/2018 03:50:01 PM | 41.800465 | -87.723370 | (41.800464977, -87.723370404) | 35.0 | 22248.0 | 60.0 | 792.0 | 6.0 | 56.0 | 13.0 | 129.0 | 23.0 | 21.418129 |
| 62 | 63.0 | Gage Park | 15.8 | 23.4 | 18.2 | 51.5 | 38.8 | 12171 | 93.0 | 8688452 | HV363336 | 01/01/2012 12:00:00 AM | 055XX S HOMAN AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | OTHER | False | False | 822 | 8 | 14 | 63.0 | 06 | 1154655.0 | 1867673.0 | 2012 | 02/04/2016 06:33:39 AM | 41.792709 | -87.708438 | (41.792708947, -87.708438164) | 49.0 | 21867.0 | 61.0 | 801.0 | 8.0 | 58.0 | 13.0 | 129.0 | 14.0 | 17.424946 |
| 63 | 64.0 | Clearing | 2.7 | 8.9 | 9.5 | 18.8 | 37.6 | 25113 | 29.0 | 9030494 | HW173536 | 01/01/2012 12:00:00 AM | 063XX W 63RD ST | 890 | THEFT | FROM BUILDING | BANK | False | False | 812 | 8 | 23 | 64.0 | 06 | 1135055.0 | 1862066.0 | 2012 | 02/10/2018 03:50:01 PM | 41.777691 | -87.780442 | (41.777690785, -87.780442441) | 35.0 | 22268.0 | 62.0 | 265.0 | 15.0 | 7.0 | 13.0 | 272.0 | 13.0 | 20.194647 |
| 64 | 65.0 | West Lawn | 5.8 | 14.9 | 9.6 | 33.6 | 39.6 | 16907 | 56.0 | 10244439 | HY432505 | 01/01/2012 12:00:00 AM | 039XX W 63RD PL | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | RESIDENCE | False | False | 823 | 8 | 13 | 65.0 | 11 | 1151174.0 | 1862198.0 | 2012 | 02/10/2018 03:50:01 PM | 41.777753 | -87.721346 | (41.777753427, -87.721345586) | 23.0 | 21867.0 | 63.0 | 238.0 | 15.0 | 58.0 | 13.0 | 276.0 | 23.0 | 32.592593 |
| 65 | 66.0 | Chicago Lawn | 7.6 | 27.9 | 17.1 | 31.2 | 40.6 | 13231 | 80.0 | 8511440 | HV188411 | 01/01/2012 12:00:00 AM | 030XX W 64TH ST | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 823 | 8 | 15 | 66.0 | 06 | 1157262.0 | 1862044.0 | 2012 | 02/04/2016 06:33:39 AM | 41.777210 | -87.699031 | (41.777209768, -87.69903082) | 44.0 | 21867.0 | 64.0 | 319.0 | 31.0 | 58.0 | 13.0 | 276.0 | 15.0 | 15.625000 |
| 66 | 67.0 | West Englewood | 4.8 | 34.4 | 35.9 | 26.3 | 40.7 | 11317 | 89.0 | 8422478 | HV100112 | 01/01/2012 12:00:00 AM | 057XX S THROOP ST | 486 | BATTERY | DOMESTIC BATTERY SIMPLE | VEHICLE NON-COMMERCIAL | False | True | 713 | 7 | 16 | 67.0 | 08B | 1168636.0 | 1866805.0 | 2012 | 09/07/2021 03:41:02 PM | 41.790037 | -87.657197 | (41.790036743, -87.657196537) | 19.0 | 22257.0 | 65.0 | 297.0 | 2.0 | 23.0 | 17.0 | 266.0 | 16.0 | 15.349910 |
| 67 | 68.0 | Englewood | 3.8 | 46.6 | 28.0 | 28.5 | 42.5 | 11888 | 94.0 | 8489737 | HV166954 | 01/01/2012 12:00:00 AM | 067XX S NORMAL BLVD | 1150 | DECEPTIVE PRACTICE | CREDIT CARD FRAUD | RESIDENCE | False | False | 722 | 7 | 6 | 68.0 | 11 | 1174118.0 | 1859976.0 | 2012 | 02/10/2018 03:50:01 PM | 41.771177 | -87.637298 | (41.771177146, -87.637298335) | 31.0 | 21559.0 | 66.0 | 479.0 | 32.0 | 11.0 | 17.0 | 201.0 | 4.0 | 15.333774 |
| 68 | 69.0 | Greater Grand Crossing | 3.6 | 29.6 | 23.0 | 16.5 | 41.0 | 17285 | 66.0 | 8577653 | HV252006 | 01/01/2012 12:01:00 AM | 001XX E 78TH ST | 2825 | OTHER OFFENSE | HARASSMENT BY TELEPHONE | APARTMENT | False | False | 623 | 6 | 6 | 69.0 | 26 | 1178686.0 | 1853331.0 | 2012 | 02/04/2016 06:33:39 AM | 41.752840 | -87.620756 | (41.752839871, -87.620755566) | 31.0 | 21546.0 | 67.0 | 475.0 | 32.0 | 61.0 | 20.0 | 228.0 | 4.0 | 15.270766 |
| 69 | 70.0 | Ashburn | 4.0 | 10.4 | 11.7 | 17.7 | 36.9 | 23482 | 37.0 | 8621247 | HV291039 | 01/01/2012 12:00:00 AM | 028XX W 84TH PL | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 835 | 8 | 18 | 70.0 | 06 | 1158673.0 | 1848550.0 | 2012 | 02/04/2016 06:33:39 AM | 41.740151 | -87.694226 | (41.740151493, -87.694225587) | 6.0 | 4300.0 | 69.0 | 217.0 | 30.0 | 8.0 | 13.0 | 226.0 | 18.0 | 20.178042 |
| 70 | 71.0 | Auburn Gresham | 4.0 | 27.6 | 28.3 | 18.5 | 41.9 | 15528 | 74.0 | 12448101 | JE331623 | 01/01/2012 12:00:00 AM | 079XX S ELIZABETH ST | 1195 | DECEPTIVE PRACTICE | FINANCIAL EXPLOITATION OF AN ELDERLY OR DISABL... | RESIDENCE | False | False | 612 | 6 | 21 | 71.0 | 11 | NaN | NaN | 2012 | 08/10/2021 03:41:28 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 15.192430 |
| 71 | 72.0 | Beverly | 0.9 | 5.1 | 8.0 | 3.7 | 40.5 | 39523 | 12.0 | 8692747 | HV368620 | 01/01/2012 12:00:00 AM | 090XX S OAKLEY AVE | 2825 | OTHER OFFENSE | HARASSMENT BY TELEPHONE | RESIDENCE | False | False | 2221 | 22 | 19 | 72.0 | 26 | 1162617.0 | 1844687.0 | 2012 | 02/04/2016 06:33:39 AM | 41.729470 | -87.679883 | (41.729469531, -87.679882632) | 33.0 | 22212.0 | 71.0 | 627.0 | 42.0 | 59.0 | 9.0 | 245.0 | 19.0 | 29.906542 |
| 72 | 73.0 | Washington Height | 1.1 | 16.9 | 20.8 | 13.7 | 42.6 | 19713 | 48.0 | 12586134 | JF104706 | 01/01/2012 12:00:00 AM | 010XX W 97TH PL | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | NaN | False | False | 2223 | 22 | 34 | 73.0 | 11 | NaN | NaN | 2012 | 01/07/2022 03:44:31 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 18.636364 |
| 73 | 74.0 | Mount Greenwood | 1.0 | 3.4 | 8.7 | 4.3 | 36.8 | 34381 | 16.0 | 9566017 | HX216941 | 01/01/2012 12:01:00 AM | 032XX W 114TH ST | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | True | 2211 | 22 | 19 | 74.0 | 20 | 1156983.0 | 1829019.0 | 2012 | 09/07/2021 03:41:02 PM | 41.686589 | -87.700943 | (41.686589225, -87.70094317) | 33.0 | 4447.0 | 73.0 | 264.0 | 42.0 | 33.0 | 9.0 | 254.0 | 19.0 | 29.601227 |
| 74 | 75.0 | Morgan Park | 0.8 | 13.2 | 15.0 | 10.8 | 40.3 | 27149 | 30.0 | 8903224 | HV577354 | 01/01/2012 12:00:00 AM | 013XX W 112TH PL | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 2234 | 22 | 34 | 75.0 | 06 | 1169238.0 | 1830118.0 | 2012 | 02/10/2018 03:50:01 PM | 41.689349 | -87.656048 | (41.689349439, -87.656047862) | 45.0 | 22212.0 | 74.0 | 663.0 | 22.0 | 13.0 | 9.0 | 263.0 | 21.0 | 23.643123 |
| 75 | 76.0 | O'Hare | 3.6 | 15.4 | 7.1 | 10.9 | 30.3 | 25828 | 24.0 | 8421756 | HV100392 | 01/01/2012 05:30:00 AM | 052XX N OAKVIEW AVE | 1365 | CRIMINAL TRESPASS | TO RESIDENCE | OTHER | True | False | 1614 | 16 | 41 | 76.0 | 26 | 1117315.0 | 1933551.0 | 2012 | 02/10/2018 03:50:01 PM | 41.974152 | -87.843985 | (41.9741522, -87.843985377) | 34.0 | 4448.0 | 75.0 | 8.0 | 29.0 | 31.0 | 12.0 | 44.0 | 41.0 | 31.203224 |
| 76 | 77.0 | Edgewater | 4.1 | 18.2 | 9.2 | 9.7 | 23.8 | 33385 | 19.0 | 11206130 | JB117907 | 01/01/2012 12:00:00 AM | 059XX N RIDGE AVE | 266 | CRIM SEXUAL ASSAULT | PREDATORY | RESIDENCE | False | True | 2013 | 20 | 48 | 77.0 | 02 | NaN | NaN | 2012 | 05/14/2019 04:05:19 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 30.444104 |
| 77 | NaN | CHICAGO | 4.7 | 19.7 | 12.9 | 19.5 | 33.5 | 28202 | NaN | 8421956 | HV100653 | 01/01/2012 11:15:00 AM | 083XX S HOLLAND RD | 860 | THEFT | RETAIL THEFT | DEPARTMENT STORE | True | False | 622 | 6 | 21 | NaN | 06 | 1175640.0 | 1849717.0 | 2012 | 02/04/2016 06:33:39 AM | 41.742991 | -87.632026 | (41.742991296, -87.632025815) | 18.0 | 21554.0 | 40.0 | 1.0 | 13.0 | 59.0 | 20.0 | 236.0 | 21.0 | NaN |
# calculates
theft_counts = Chicago.groupby('Community Area').apply(lambda x: (x['Primary Type'] == 'THEFT').sum()).reset_index()
theft_counts.columns = ['Community Area Number', 'Theft Count']
# Merge the theft counts with the socioeconomicMerge dataframe
socioeconomicMerge = socioeconomicMerge.merge(theft_counts, on='Community Area Number', how='left')
# Fill NaN values in 'Theft Count' column with 0 (assuming that NaN means no thefts were reported)
#socioeconomicMerge['Theft Count'] = socioeconomicMerge['Theft Count'].fillna(0)
socioeconomicMerge
| Community Area Number | COMMUNITY AREA NAME | PERCENT OF HOUSING CROWDED | PERCENT HOUSEHOLDS BELOW POVERTY | PERCENT AGED 16+ UNEMPLOYED | PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA | PERCENT AGED UNDER 18 OR OVER 64 | PER CAPITA INCOME | HARDSHIP INDEX | ID | Case Number | Date | Block | IUCR | Primary Type | Description | Location Description | Arrest | Domestic | Beat | District | Ward | Community Area | FBI Code | X Coordinate | Y Coordinate | Year | Updated On | Latitude | Longitude | Location | Historical Wards 2003-2015 | Zip Codes | Community Areas | Census Tracts | Wards | Boundaries - ZIP Codes | Police Districts | Police Beats | Wards 2023- | Theft Percentage | Theft Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | Rogers Park | 7.7 | 23.6 | 8.7 | 18.2 | 27.5 | 23939 | 39.0 | 8522872 | HV199799 | 01/01/2012 12:01:00 AM | 068XX N SHERIDAN RD | 890 | THEFT | FROM BUILDING | RESIDENCE | False | False | 2431 | 24 | 49 | 1.0 | 06 | 1166981.0 | 1945453.0 | 2012 | 02/04/2016 06:33:39 AM | 42.005888 | -87.661005 | (42.005887804, -87.661005031) | 3.0 | 21853.0 | 10.0 | 267.0 | 5.0 | 9.0 | 11.0 | 39.0 | 49.0 | 20.071159 | 959.0 |
| 1 | 2.0 | West Ridge | 7.8 | 17.2 | 8.8 | 20.8 | 38.5 | 23040 | 46.0 | 8481432 | HV158191 | 01/01/2012 12:00:00 AM | 066XX N SEELEY AVE | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | RESIDENCE | False | False | 2412 | 24 | 50 | 2.0 | 02 | 1161424.0 | 1944172.0 | 2012 | 02/10/2018 03:50:01 PM | 42.002491 | -87.681486 | (42.002490631, -87.681485671) | 42.0 | 22528.0 | 20.0 | 320.0 | 27.0 | 12.0 | 11.0 | 46.0 | 40.0 | 24.220322 | 963.0 |
| 2 | 3.0 | Uptown | 3.8 | 24.0 | 8.9 | 11.8 | 22.2 | 35787 | 20.0 | 9786892 | HX434641 | 01/01/2012 12:00:00 AM | 008XX W EASTWOOD AVE | 266 | CRIM SEXUAL ASSAULT | PREDATORY | RESIDENCE | False | True | 1914 | 19 | 46 | 3.0 | 02 | 1169806.0 | 1931096.0 | 2012 | 02/10/2018 03:50:01 PM | 41.966431 | -87.651032 | (41.966430564, -87.651032417) | 37.0 | 22616.0 | 31.0 | 19.0 | 39.0 | 15.0 | 5.0 | 4.0 | 46.0 | 27.005240 | 1340.0 |
| 3 | 4.0 | Lincoln Square | 3.4 | 10.9 | 8.2 | 13.4 | 25.5 | 37524 | 17.0 | 8639260 | HV313362 | 01/01/2012 12:01:00 AM | 048XX N CLAREMONT AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 2031 | 20 | 47 | 4.0 | 06 | 1159822.0 | 1932094.0 | 2012 | 02/04/2016 06:33:39 AM | 41.969381 | -87.687714 | (41.969381427, -87.687714236) | 13.0 | 21849.0 | 6.0 | 54.0 | 18.0 | 20.0 | 2.0 | 61.0 | 47.0 | 29.720430 | 691.0 |
| 4 | 5.0 | North Center | 0.3 | 7.5 | 5.2 | 4.5 | 26.2 | 57123 | 6.0 | 8719401 | HV387013 | 01/01/2012 12:00:00 AM | 040XX N HOYNE AVE | 1563 | SEX OFFENSE | CRIMINAL SEXUAL ABUSE | RESIDENCE | False | False | 1911 | 19 | 47 | 5.0 | 17 | 1161635.0 | 1926718.0 | 2012 | 02/04/2016 06:33:39 AM | 41.954592 | -87.681198 | (41.954591739, -87.681198274) | 13.0 | 21538.0 | 46.0 | 623.0 | 18.0 | 39.0 | 5.0 | 10.0 | 47.0 | 35.475444 | 679.0 |
| 5 | 6.0 | Lake View | 1.1 | 11.4 | 4.7 | 2.6 | 17.0 | 60058 | 5.0 | 8856125 | HV529988 | 01/01/2012 12:00:00 AM | 006XX W CORNELIA AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1925 | 19 | 46 | 6.0 | 06 | 1171080.0 | 1923465.0 | 2012 | 02/10/2018 03:50:01 PM | 41.945463 | -87.646573 | (41.945462922, -87.646573015) | 38.0 | 4449.0 | 57.0 | 730.0 | 25.0 | 22.0 | 5.0 | 18.0 | 44.0 | 37.566967 | 2875.0 |
| 6 | 7.0 | Lincoln Park | 0.8 | 12.3 | 5.1 | 3.6 | 21.5 | 71551 | 2.0 | 8424740 | HV103697 | 01/01/2012 12:00:00 AM | 014XX W FULLERTON AVE | 460 | BATTERY | SIMPLE | APARTMENT | False | False | 1931 | 19 | 32 | 7.0 | 08B | 1166102.0 | 1916039.0 | 2012 | 02/10/2018 03:50:01 PM | 41.925194 | -87.665083 | (41.925193578, -87.66508297) | 16.0 | 21190.0 | 68.0 | 770.0 | 11.0 | 16.0 | 5.0 | 173.0 | 32.0 | 44.323671 | 2202.0 |
| 7 | 8.0 | Near North Side | 1.9 | 12.9 | 7.0 | 2.5 | 22.6 | 88669 | 1.0 | 8904856 | HV578917 | 01/01/2012 12:00:00 AM | 002XX E CHESTNUT ST | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1833 | 18 | 42 | 8.0 | 06 | 1178637.0 | 1906397.0 | 2012 | 02/10/2018 03:50:01 PM | 41.898458 | -87.619319 | (41.898458275, -87.619318967) | 22.0 | 21182.0 | 37.0 | 233.0 | 11.0 | 6.0 | 14.0 | 71.0 | 2.0 | 48.858488 | 5500.0 |
| 8 | 9.0 | Edison Park | 1.1 | 3.3 | 6.5 | 7.4 | 35.3 | 40959 | 8.0 | 9274751 | HW419186 | 01/01/2012 12:00:00 AM | 073XX N ORIOLE AVE | 2825 | OTHER OFFENSE | HARASSMENT BY TELEPHONE | RESIDENCE | False | False | 1611 | 16 | 41 | 9.0 | 26 | 1124738.0 | 1948147.0 | 2012 | 02/10/2018 03:50:01 PM | 42.014085 | -87.816364 | (42.014085475, -87.81636423) | 34.0 | 22243.0 | 77.0 | 653.0 | 29.0 | 17.0 | 12.0 | 34.0 | 41.0 | 22.442244 | 68.0 |
| 9 | 10.0 | Norwood Park | 2.0 | 5.4 | 9.0 | 11.5 | 39.5 | 32875 | 21.0 | 9055356 | HW199594 | 01/01/2012 12:00:00 AM | 057XX N WEST CIRCLE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | STREET | False | False | 1612 | 16 | 41 | 10.0 | 06 | 1127968.0 | 1937874.0 | 2012 | 02/10/2018 03:50:01 PM | 41.985841 | -87.804712 | (41.985841282, -87.8047123) | 34.0 | 22243.0 | 36.0 | 733.0 | 29.0 | 17.0 | 12.0 | 45.0 | 41.0 | 28.156028 | 397.0 |
| 10 | 11.0 | Jefferson Park | 2.7 | 8.6 | 12.4 | 13.4 | 35.5 | 27751 | 25.0 | 11865218 | JC471748 | 01/01/2012 12:00:00 AM | 062XX W FOSTER AVE | 1750 | OFFENSE INVOLVING CHILDREN | CHILD ABUSE | CHURCH/SYNAGOGUE/PLACE OF WORSHIP | False | True | 1622 | 16 | 45 | 11.0 | 08B | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25.854701 | 363.0 |
| 11 | 12.0 | Forest Glen | 1.1 | 7.5 | 6.8 | 4.9 | 40.5 | 44164 | 11.0 | 8548806 | HV224880 | 01/01/2012 12:01:00 AM | 062XX N KEYSTONE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | STREET | False | False | 1711 | 17 | 39 | 12.0 | 06 | 1148230.0 | 1941153.0 | 2012 | 02/04/2016 06:33:39 AM | 41.994472 | -87.730104 | (41.9944717, -87.730103763) | 28.0 | 22532.0 | 12.0 | 713.0 | 38.0 | 18.0 | 1.0 | 53.0 | 39.0 | 30.292599 | 176.0 |
| 12 | 13.0 | North Park | 3.9 | 13.2 | 9.9 | 14.4 | 39.0 | 26576 | 33.0 | 8679089 | HV354082 | 01/01/2012 12:01:00 AM | 040XX W PETERSON AVE | 2820 | OTHER OFFENSE | TELEPHONE THREAT | MEDICAL/DENTAL OFFICE | False | False | 1711 | 17 | 39 | 13.0 | 26 | 1148144.0 | 1939564.0 | 2012 | 02/04/2016 06:33:39 AM | 41.990113 | -87.730461 | (41.990113051, -87.730461261) | 28.0 | 22532.0 | 13.0 | 748.0 | 38.0 | 18.0 | 1.0 | 53.0 | 39.0 | 30.252101 | 324.0 |
| 13 | 14.0 | Albany Park | 11.3 | 19.2 | 10.0 | 32.9 | 32.0 | 21323 | 53.0 | 8519160 | HV194208 | 01/01/2012 12:00:00 AM | 047XX N HARDING AVE | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | False | 1723 | 17 | 39 | 14.0 | 17 | 1149205.0 | 1931162.0 | 2012 | 02/04/2016 06:33:39 AM | 41.967037 | -87.726777 | (41.96703686, -87.726777496) | 28.0 | 21849.0 | 14.0 | 117.0 | 12.0 | 20.0 | 1.0 | 9.0 | 33.0 | 20.816327 | 612.0 |
| 14 | 15.0 | Portage Park | 4.1 | 11.6 | 12.6 | 19.3 | 34.0 | 24336 | 35.0 | 8460773 | HV138026 | 01/01/2012 12:00:00 AM | 050XX W WARWICK AVE | 1563 | SEX OFFENSE | CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 1634 | 16 | 45 | 15.0 | 17 | 1142107.0 | 1924463.0 | 2012 | 09/07/2021 03:41:02 PM | 41.948789 | -87.753043 | (41.948789141, -87.753043017) | 20.0 | 22618.0 | 15.0 | 360.0 | 50.0 | 21.0 | 12.0 | 26.0 | 30.0 | 25.741142 | 1068.0 |
| 15 | 16.0 | Irving Park | 6.3 | 13.1 | 10.0 | 22.4 | 31.6 | 27249 | 34.0 | 8612446 | HV286559 | 01/01/2012 12:01:00 AM | 032XX N KILDARE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1731 | 17 | 31 | 16.0 | 06 | 1147143.0 | 1921400.0 | 2012 | 02/04/2016 06:33:39 AM | 41.940289 | -87.734610 | (41.940288955, -87.734610033) | 7.0 | 22618.0 | 16.0 | 328.0 | 21.0 | 21.0 | 1.0 | 25.0 | 30.0 | 21.792261 | 856.0 |
| 16 | 17.0 | Dunning | 5.2 | 10.6 | 10.0 | 16.2 | 33.6 | 26282 | 28.0 | 8630608 | HV304221 | 01/01/2012 12:00:00 AM | 065XX W BYRON ST | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 1632 | 16 | 38 | 17.0 | 17 | 1132230.0 | 1925250.0 | 2012 | 02/04/2016 06:33:39 AM | 41.951127 | -87.789331 | (41.951126516, -87.789331374) | 25.0 | 22254.0 | 17.0 | 444.0 | 19.0 | 52.0 | 12.0 | 17.0 | 38.0 | 23.402007 | 443.0 |
| 17 | 18.0 | Montclaire | 8.1 | 15.3 | 13.8 | 23.5 | 38.6 | 22014 | 50.0 | 13184630 | JG330270 | 01/01/2012 12:00:00 AM | 070XX W DIVERSEY AVE | 1754 | OFFENSE INVOLVING CHILDREN | AGGRAVATED SEXUAL ASSAULT OF CHILD BY FAMILY M... | APARTMENT | False | True | 2511 | 25 | 29 | 18.0 | 02 | NaN | NaN | 2012 | 08/23/2023 03:41:55 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 20.079787 | 151.0 |
| 18 | 19.0 | Belmont Cragin | 10.8 | 18.7 | 14.6 | 37.3 | 37.3 | 15461 | 70.0 | 10433096 | HZ170962 | 01/01/2012 12:00:00 AM | 026XX N MC VICKER AVE | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | True | True | 2512 | 25 | 29 | 19.0 | 17 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 19.055862 | 1211.0 |
| 19 | 20.0 | Hermosa | 6.9 | 20.5 | 13.1 | 41.6 | 36.4 | 15089 | 71.0 | 11002368 | JA329407 | 01/01/2012 12:00:00 AM | 021XX N KENNETH AVE | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | False | True | 2522 | 25 | 31 | 20.0 | 20 | NaN | NaN | 2012 | 11/27/2017 03:53:35 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.113281 | 330.0 |
| 20 | 21.0 | Avondale | 6.0 | 15.3 | 9.2 | 24.7 | 31.0 | 20039 | 42.0 | 9485925 | HX138962 | 01/01/2012 12:00:00 AM | 033XX N KEDZIE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | OTHER | False | False | 1733 | 17 | 33 | 21.0 | 06 | 1154463.0 | 1921987.0 | 2012 | 02/04/2016 06:33:39 AM | 41.941756 | -87.707691 | (41.941756281, -87.70769069) | 15.0 | 21538.0 | 22.0 | 138.0 | 12.0 | 39.0 | 1.0 | 23.0 | 35.0 | 21.376147 | 699.0 |
| 21 | 22.0 | Logan Square | 3.2 | 16.8 | 8.2 | 14.8 | 26.2 | 31908 | 23.0 | 8580117 | HV254276 | 01/01/2012 12:00:00 AM | 037XX W LYNDALE ST | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | True | 2525 | 25 | 35 | 22.0 | 20 | 1151032.0 | 1914695.0 | 2012 | 02/04/2016 06:33:39 AM | 41.921814 | -87.720493 | (41.921814446, -87.720492698) | 15.0 | 22535.0 | 23.0 | 74.0 | 12.0 | 1.0 | 6.0 | 187.0 | 35.0 | 28.799527 | 1948.0 |
| 22 | 23.0 | Humboldt park | 14.8 | 33.9 | 17.3 | 35.4 | 38.0 | 13781 | 85.0 | 10440733 | HZ179414 | 01/01/2012 12:00:00 AM | 038XX W OHIO ST | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | APARTMENT | False | False | 1122 | 11 | 27 | 23.0 | 11 | NaN | NaN | 2012 | 03/09/2016 04:05:56 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14.008582 | 1567.0 |
| 23 | 24.0 | West Town | 2.3 | 14.7 | 6.6 | 12.9 | 21.7 | 43198 | 10.0 | 8647985 | HV322951 | 01/01/2012 12:00:00 AM | 015XX N CAMPBELL AVE | 1305 | CRIMINAL DAMAGE | CRIMINAL DEFACEMENT | RESIDENCE-GARAGE | False | False | 1423 | 14 | 1 | 24.0 | 14 | 1159459.0 | 1910195.0 | 2012 | 02/04/2016 06:33:39 AM | 41.909297 | -87.689654 | (41.909296674, -87.689653613) | 10.0 | 21560.0 | 25.0 | 302.0 | 41.0 | 4.0 | 7.0 | 62.0 | 1.0 | 32.515020 | 3139.0 |
| 24 | 25.0 | Austin | 6.3 | 28.6 | 22.6 | 24.4 | 37.9 | 15957 | 73.0 | 10401057 | HZ137709 | 01/01/2012 12:00:00 AM | 050XX W HURON ST | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 1532 | 15 | 28 | 25.0 | 17 | NaN | NaN | 2012 | 02/11/2016 03:47:22 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 15.036232 | 3154.0 |
| 25 | 26.0 | West Garfield Park | 9.4 | 41.7 | 25.8 | 24.5 | 43.6 | 10934 | 92.0 | 8421939 | HV100656 | 01/01/2012 12:00:00 AM | 044XX W WEST END AVE | 890 | THEFT | FROM BUILDING | RESIDENCE | False | False | 1113 | 11 | 28 | 26.0 | 06 | 1146850.0 | 1900608.0 | 2012 | 02/04/2016 06:33:39 AM | 41.883239 | -87.736219 | (41.883239213, -87.73621892) | 11.0 | 21572.0 | 27.0 | 732.0 | 23.0 | 30.0 | 16.0 | 90.0 | 28.0 | 12.610586 | 841.0 |
| 26 | 27.0 | East Garfield Park | 8.2 | 42.4 | 19.6 | 21.3 | 43.2 | 12961 | 83.0 | 9087981 | HW232769 | 01/01/2012 12:00:00 AM | 008XX S INDEPENDENCE BLVD | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 1133 | 11 | 24 | 27.0 | 06 | 1151390.0 | 1896019.0 | 2012 | 02/10/2018 03:50:01 PM | 41.870559 | -87.719668 | (41.870558601, -87.719668116) | 36.0 | 21572.0 | 28.0 | 704.0 | 14.0 | 30.0 | 16.0 | 141.0 | 24.0 | 13.619433 | 841.0 |
| 27 | 28.0 | Near West Side | 3.8 | 20.6 | 10.7 | 9.6 | 22.2 | 44689 | 15.0 | 8678186 | HV352296 | 01/01/2012 12:00:00 AM | 013XX W WASHBURNE AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | False | 1231 | 12 | 2 | 28.0 | 20 | 1167691.0 | 1894516.0 | 2012 | 02/04/2016 06:33:39 AM | 41.866099 | -87.659865 | (41.866098868, -87.659865054) | 48.0 | 14920.0 | 29.0 | 96.0 | 26.0 | 43.0 | 15.0 | 150.0 | 28.0 | 35.867363 | 3364.0 |
| 28 | 29.0 | North Lawndale | 7.4 | 43.1 | 21.2 | 27.6 | 42.7 | 12034 | 87.0 | 9467940 | HX120966 | 01/01/2012 12:00:00 AM | 015XX S KEELER AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 1012 | 10 | 24 | 29.0 | 06 | 1148635.0 | 1892193.0 | 2012 | 02/10/2018 03:50:01 PM | 41.860113 | -87.729881 | (41.860113198, -87.729881467) | 36.0 | 21569.0 | 30.0 | 761.0 | 14.0 | 57.0 | 21.0 | 109.0 | 24.0 | 13.414282 | 1392.0 |
| 29 | 30.0 | South Lawndale | 15.2 | 30.7 | 15.8 | 54.8 | 33.8 | 10402 | 96.0 | 11861733 | JC473689 | 01/01/2012 12:00:00 AM | 022XX S CALIFORNIA AVE | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | RESIDENCE | False | True | 1033 | 10 | 12 | 30.0 | 02 | NaN | NaN | 2012 | 10/16/2019 09:37:36 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.730236 | 965.0 |
| 30 | 31.0 | Lower West Side | 9.6 | 25.8 | 15.8 | 40.7 | 32.6 | 16444 | 76.0 | 8538123 | HV214939 | 01/01/2012 12:01:00 AM | 021XX W 18TH ST | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | RESIDENCE | False | False | 1223 | 12 | 25 | 31.0 | 02 | 1162499.0 | 1891389.0 | 2012 | 02/04/2016 06:33:39 AM | 41.857628 | -87.679013 | (41.857628272, -87.679012753) | 8.0 | 14920.0 | 33.0 | 4.0 | 26.0 | 43.0 | 15.0 | 121.0 | 25.0 | 20.408163 | 670.0 |
| 31 | 32.0 | Loop | 1.5 | 14.7 | 5.7 | 3.1 | 13.5 | 65526 | 3.0 | 11655969 | JC225381 | 01/01/2012 12:00:00 AM | 001XX W RANDOLPH ST | 486 | BATTERY | DOMESTIC BATTERY SIMPLE | RESIDENCE | False | True | 122 | 1 | 42 | 32.0 | 08B | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 53.431563 | 4134.0 |
| 32 | 33.0 | Near South Side | 1.3 | 13.8 | 4.9 | 7.4 | 21.8 | 59077 | 7.0 | 8812790 | HV485714 | 01/01/2012 12:01:00 AM | 022XX S WABASH AVE | 1150 | DECEPTIVE PRACTICE | CREDIT CARD FRAUD | OTHER | False | False | 131 | 1 | 2 | 33.0 | 11 | 1177098.0 | 1889498.0 | 2012 | 02/10/2018 03:50:01 PM | 41.852121 | -87.625483 | (41.852121445, -87.625483421) | 48.0 | 21194.0 | 34.0 | 193.0 | 9.0 | 40.0 | 22.0 | 94.0 | 8.0 | 39.086022 | 727.0 |
| 33 | 34.0 | Armour Square | 5.7 | 40.1 | 16.7 | 34.5 | 38.3 | 16148 | 82.0 | 8421660 | HV100180 | 01/01/2012 01:20:00 AM | 002XX W 26TH ST | 430 | BATTERY | AGGRAVATED: OTHER DANG WEAPON | PARKING LOT/GARAGE(NON.RESID.) | True | False | 914 | 9 | 11 | 34.0 | 04B | 1174834.0 | 1887065.0 | 2012 | 02/10/2018 03:50:01 PM | 41.845496 | -87.633866 | (41.84549602, -87.633865582) | 26.0 | 21194.0 | 35.0 | 346.0 | 48.0 | 40.0 | 23.0 | 157.0 | 7.0 | 27.890268 | 427.0 |
| 34 | 35.0 | Douglas | 1.8 | 29.6 | 18.2 | 14.3 | 30.7 | 23791 | 47.0 | 10532867 | HZ276514 | 01/01/2012 12:00:00 AM | 036XX S RHODES AVE | 1563 | SEX OFFENSE | CRIMINAL SEXUAL ABUSE | APARTMENT | False | True | 212 | 2 | 4 | 35.0 | 17 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 24.791893 | 685.0 |
| 35 | 36.0 | Oakland | 1.3 | 39.7 | 28.7 | 18.4 | 40.4 | 19252 | 78.0 | 8421472 | HV100138 | 01/01/2012 01:38:00 AM | 042XX S DREXEL BLVD | 486 | BATTERY | DOMESTIC BATTERY SIMPLE | APARTMENT | False | True | 2123 | 2 | 4 | 36.0 | 08B | 1182889.0 | 1876982.0 | 2012 | 02/10/2018 03:50:01 PM | 41.817644 | -87.604619 | (41.817643766, -87.604618853) | 1.0 | 4301.0 | 2.0 | 220.0 | 10.0 | 36.0 | 24.0 | 104.0 | 9.0 | 20.984456 | 162.0 |
| 36 | 37.0 | Fuller Park | 3.2 | 51.2 | 33.9 | 26.6 | 44.9 | 10432 | 97.0 | 9836248 | HX484599 | 01/01/2012 12:00:00 AM | 001XX W GARFIELD BLVD | 1130 | DECEPTIVE PRACTICE | FRAUD OR CONFIDENCE GAME | CURRENCY EXCHANGE | True | False | 225 | 2 | 3 | 37.0 | 11 | 1176228.0 | 1868523.0 | 2012 | 02/10/2018 03:50:01 PM | 41.794584 | -87.629307 | (41.794583892, -87.629307346) | 12.0 | 21559.0 | 66.0 | 166.0 | 9.0 | 37.0 | 24.0 | 111.0 | 20.0 | 20.540098 | 251.0 |
| 37 | 38.0 | Grand Boulevard | 3.3 | 29.3 | 24.3 | 15.9 | 39.5 | 23472 | 57.0 | 8424419 | HV102059 | 01/01/2012 03:00:00 AM | 046XX S PRAIRIE AVE | 281 | CRIM SEXUAL ASSAULT | NON-AGGRAVATED | RESIDENCE | False | False | 221 | 2 | 3 | 38.0 | 02 | 1178818.0 | 1874416.0 | 2012 | 02/10/2018 03:50:01 PM | 41.810696 | -87.619631 | (41.810696214, -87.619630513) | 12.0 | 4301.0 | 4.0 | 354.0 | 9.0 | 36.0 | 24.0 | 98.0 | 8.0 | 17.389187 | 714.0 |
| 38 | 39.0 | Kenwood | 2.4 | 21.7 | 15.7 | 11.3 | 35.4 | 35911 | 26.0 | 8916155 | HV588860 | 01/01/2012 12:00:00 AM | 050XX S LAKE SHORE DR W | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | APARTMENT | False | False | 222 | 2 | 4 | 39.0 | 06 | 1188639.0 | 1871868.0 | 2012 | 02/10/2018 03:50:01 PM | 41.803475 | -87.583690 | (41.803474876, -87.583690122) | 1.0 | 21192.0 | 5.0 | 400.0 | 33.0 | 10.0 | 24.0 | 113.0 | 3.0 | 28.459821 | 510.0 |
| 39 | 40.0 | Washington Park | 5.6 | 42.1 | 28.6 | 25.4 | 42.8 | 13785 | 88.0 | 11571926 | JC122968 | 01/01/2012 12:00:00 AM | 059XX S INDIANA AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | APARTMENT | True | True | 232 | 2 | 20 | 40.0 | 17 | NaN | NaN | 2012 | 08/01/2019 03:45:33 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14.751732 | 511.0 |
| 40 | 41.0 | Hyde Park | 1.5 | 18.4 | 8.4 | 4.3 | 26.2 | 39056 | 14.0 | 9091480 | HW236506 | 01/01/2012 12:00:00 AM | 055XX S COTTAGE GROVE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 235 | 2 | 5 | 41.0 | 06 | 1182527.0 | 1868455.0 | 2012 | 02/10/2018 03:50:01 PM | 41.794253 | -87.606211 | (41.794253414, -87.606211387) | 32.0 | 22260.0 | 8.0 | 401.0 | 33.0 | 60.0 | 24.0 | 132.0 | 3.0 | 34.500784 | 660.0 |
| 41 | 42.0 | Woodlawn | 2.9 | 30.7 | 23.4 | 16.5 | 36.1 | 18672 | 58.0 | 8821354 | HV494310 | 01/01/2012 12:01:00 AM | 063XX S ST LAWRENCE AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | STREET | False | False | 312 | 3 | 20 | 42.0 | 06 | 1181324.0 | 1863129.0 | 2012 | 02/10/2018 03:50:01 PM | 41.779666 | -87.610787 | (41.779666218, -87.61078682) | 53.0 | 22260.0 | 9.0 | 332.0 | 4.0 | 60.0 | 18.0 | 277.0 | 20.0 | 15.501576 | 836.0 |
| 42 | 43.0 | South Shore | 2.8 | 31.1 | 20.0 | 14.0 | 35.7 | 19398 | 55.0 | 9784782 | HX433977 | 01/01/2012 12:00:00 AM | 078XX S JEFFERY BLVD | 265 | CRIM SEXUAL ASSAULT | AGGRAVATED: OTHER | RESIDENCE | False | True | 414 | 4 | 8 | 43.0 | 02 | 1190897.0 | 1853347.0 | 2012 | 09/07/2021 03:41:02 PM | 41.752598 | -87.576007 | (41.752597535, -87.576007285) | 9.0 | 22538.0 | 39.0 | 420.0 | 35.0 | 24.0 | 19.0 | 222.0 | 10.0 | 16.425246 | 1905.0 |
| 43 | 44.0 | Chatham | 3.3 | 27.8 | 24.0 | 14.5 | 40.3 | 18881 | 60.0 | 11012707 | JA342665 | 01/01/2012 12:00:00 AM | 081XX S EVANS AVE | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | OTHER | False | False | 631 | 6 | 6 | 44.0 | 11 | NaN | NaN | 2012 | 07/11/2017 03:48:22 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 22.336009 | 1614.0 |
| 44 | 45.0 | Avalon Park | 1.4 | 17.2 | 21.1 | 10.6 | 39.3 | 24454 | 41.0 | 8453833 | HV101813 | 01/01/2012 12:01:00 AM | 080XX S WOODLAWN AVE | 1320 | CRIMINAL DAMAGE | TO VEHICLE | STREET | False | False | 411 | 4 | 8 | 45.0 | 14 | 1185609.0 | 1851926.0 | 2012 | 02/10/2018 03:50:01 PM | 41.748824 | -87.595430 | (41.748824266, -87.595429995) | 9.0 | 21546.0 | 41.0 | 133.0 | 35.0 | 61.0 | 19.0 | 224.0 | 10.0 | 25.055432 | 452.0 |
| 45 | 46.0 | South Chicago | 4.7 | 29.8 | 19.7 | 26.6 | 41.1 | 16579 | 75.0 | 8644620 | HV319861 | 01/01/2012 12:00:00 AM | 087XX S ESCANABA AVE | 4651 | OTHER OFFENSE | SEX OFFENDER: FAIL REG NEW ADD | RESIDENCE | True | False | 423 | 4 | 10 | 46.0 | 26 | 1196905.0 | 1847568.0 | 2012 | 02/04/2016 06:33:39 AM | 41.736592 | -87.554183 | (41.736592286, -87.554182677) | 47.0 | 21202.0 | 42.0 | 509.0 | 47.0 | 25.0 | 19.0 | 238.0 | 6.0 | 14.649984 | 925.0 |
| 46 | 47.0 | Burnside | 6.8 | 33.0 | 18.6 | 19.3 | 42.7 | 12515 | 79.0 | 9535590 | HX189319 | 01/01/2012 12:00:00 AM | 092XX S DREXEL AVE | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | APARTMENT | False | False | 413 | 4 | 8 | 47.0 | 11 | 1184166.0 | 1844031.0 | 2012 | 02/10/2018 03:50:01 PM | 41.727193 | -87.600964 | (41.727193361, -87.600963809) | 9.0 | 21546.0 | 43.0 | 472.0 | 35.0 | 61.0 | 19.0 | 246.0 | 10.0 | 17.415730 | 93.0 |
| 47 | 48.0 | Calumet Heights | 2.1 | 11.5 | 20.0 | 11.0 | 44.0 | 28887 | 38.0 | 8421496 | HV100177 | 01/01/2012 02:10:00 AM | 023XX E 91ST ST | 2025 | NARCOTICS | POSS: HALLUCINOGENS | STREET | True | False | 413 | 4 | 7 | 48.0 | 18 | 1193236.0 | 1845085.0 | 2012 | 02/10/2018 03:50:01 PM | 41.729869 | -87.567705 | (41.729869072, -87.56770535) | 43.0 | 21202.0 | 44.0 | 492.0 | 37.0 | 25.0 | 19.0 | 246.0 | 5.0 | 29.205852 | 559.0 |
| 48 | 49.0 | Roseland | 2.5 | 19.8 | 20.3 | 16.9 | 41.2 | 17949 | 52.0 | 8630662 | HV304328 | 01/01/2012 12:00:00 AM | 111XX S PARNELL AVE | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 2233 | 22 | 34 | 49.0 | 17 | 1174621.0 | 1831009.0 | 2012 | 02/04/2016 06:33:39 AM | 41.691677 | -87.636314 | (41.691676649, -87.636314398) | 45.0 | 21861.0 | 45.0 | 486.0 | 22.0 | 19.0 | 9.0 | 258.0 | 21.0 | 15.912117 | 1434.0 |
| 49 | 50.0 | Pullman | 1.5 | 21.6 | 22.8 | 13.1 | 38.6 | 20588 | 51.0 | 10579715 | HZ328636 | 01/01/2012 12:00:00 AM | 007XX E 105TH PL | 1562 | SEX OFFENSE | AGG CRIMINAL SEXUAL ABUSE | RESIDENCE | False | True | 512 | 5 | 9 | 50.0 | 17 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.454690 | 207.0 |
| 50 | 51.0 | South Deering | 4.0 | 29.2 | 16.3 | 21.0 | 39.5 | 14685 | 65.0 | 9006102 | HW153435 | 01/01/2012 12:01:00 AM | 097XX S BRENNAN AVE | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 431 | 4 | 7 | 51.0 | 06 | 1193243.0 | 1840695.0 | 2012 | 02/10/2018 03:50:01 PM | 41.717822 | -87.567823 | (41.717822323, -87.567822714) | 43.0 | 21202.0 | 48.0 | 252.0 | 37.0 | 25.0 | 19.0 | 249.0 | 5.0 | 17.918314 | 408.0 |
| 51 | 52.0 | East Side | 6.8 | 19.2 | 12.1 | 31.9 | 42.8 | 17104 | 64.0 | 9130410 | HW275140 | 01/01/2012 12:00:00 AM | 109XX S BUFFALO AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | True | 432 | 4 | 10 | 52.0 | 20 | 1199876.0 | 1833114.0 | 2012 | 09/07/2021 03:41:02 PM | 41.696855 | -87.543784 | (41.696854988, -87.54378378) | 47.0 | 21202.0 | 49.0 | 602.0 | 47.0 | 25.0 | 19.0 | 247.0 | 6.0 | 15.531178 | 269.0 |
| 52 | 53.0 | West Pullman | 3.3 | 25.9 | 19.4 | 20.5 | 42.1 | 16563 | 62.0 | 10928592 | JA154782 | 01/01/2012 12:00:00 AM | 0000X E 118TH PL | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | True | True | 532 | 5 | 9 | 53.0 | 20 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14.940518 | 854.0 |
| 53 | 54.0 | Riverdale | 5.8 | 56.5 | 34.6 | 27.5 | 51.5 | 8201 | 98.0 | 12364874 | JE229312 | 01/01/2012 12:00:00 AM | 131XX S FORRESTVILLE AVE | 1581 | SEX OFFENSE | NON-CONSENSUAL DISSEMINATION OF PRIVATE SEXUAL... | RESIDENCE | False | False | 533 | 5 | 9 | 54.0 | 17 | NaN | NaN | 2012 | 05/14/2021 03:40:44 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11.047619 | 174.0 |
| 54 | 55.0 | Hegewisch | 3.3 | 17.1 | 9.6 | 19.2 | 42.9 | 22677 | 44.0 | 8438703 | HV116214 | 01/01/2012 12:01:00 AM | 134XX S AVENUE M | 2820 | OTHER OFFENSE | TELEPHONE THREAT | RESIDENCE | False | True | 433 | 4 | 10 | 55.0 | 26 | 1201758.0 | 1816513.0 | 2012 | 02/10/2018 03:50:01 PM | 41.651253 | -87.537455 | (41.65125265, -87.537454574) | 47.0 | 22250.0 | 52.0 | 787.0 | 47.0 | 26.0 | 19.0 | 259.0 | 6.0 | 19.376694 | 143.0 |
| 55 | 56.0 | Garfield Ridge | 2.6 | 8.8 | 11.3 | 19.3 | 38.1 | 26353 | 32.0 | 8964421 | HW112128 | 01/01/2012 12:01:00 AM | 044XX S KILPATRICK AVE | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 815 | 8 | 23 | 56.0 | 06 | 1145771.0 | 1874717.0 | 2012 | 02/10/2018 03:50:01 PM | 41.812211 | -87.740837 | (41.812211369, -87.740837061) | 35.0 | 22248.0 | 53.0 | 566.0 | 28.0 | 56.0 | 13.0 | 105.0 | 22.0 | 22.066694 | 536.0 |
| 56 | 57.0 | Archer Heights | 8.5 | 14.1 | 16.5 | 35.9 | 39.2 | 16134 | 67.0 | 8550554 | HV226299 | 01/01/2012 12:01:00 AM | 050XX S KOLIN AVE | 1752 | OFFENSE INVOLVING CHILDREN | AGG CRIM SEX ABUSE FAM MEMBER | RESIDENCE | False | False | 815 | 8 | 23 | 57.0 | 20 | 1148213.0 | 1870883.0 | 2012 | 02/10/2018 03:50:01 PM | 41.801644 | -87.731978 | (41.801643749, -87.731978113) | 35.0 | 22248.0 | 54.0 | 697.0 | 8.0 | 56.0 | 13.0 | 105.0 | 14.0 | 21.171548 | 253.0 |
| 57 | 58.0 | Brighton Park | 14.4 | 23.6 | 13.9 | 45.1 | 39.3 | 13089 | 84.0 | 10774674 | HZ540883 | 01/01/2012 12:01:00 AM | 045XX S TROY ST | 266 | CRIM SEXUAL ASSAULT | PREDATORY | RESIDENCE | False | True | 922 | 9 | 14 | 58.0 | 02 | NaN | NaN | 2012 | 09/07/2021 03:41:02 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 15.966123 | 509.0 |
| 58 | 59.0 | McKinley Park | 7.2 | 18.7 | 13.4 | 32.9 | 35.6 | 16954 | 61.0 | 8558693 | HV234189 | 01/01/2012 12:00:00 AM | 037XX S WOLCOTT AVE | 610 | BURGLARY | FORCIBLE ENTRY | RESIDENCE | False | False | 912 | 9 | 11 | 59.0 | 05 | 1164301.0 | 1879957.0 | 2012 | 02/04/2016 06:33:39 AM | 41.826220 | -87.672721 | (41.826219832, -87.67272111) | 26.0 | 14924.0 | 56.0 | 720.0 | 1.0 | 37.0 | 23.0 | 165.0 | 12.0 | 27.761194 | 372.0 |
| 59 | 60.0 | Bridgeport | 4.5 | 18.9 | 13.7 | 22.2 | 31.3 | 22694 | 43.0 | 8697316 | HV373879 | 01/01/2012 12:00:00 AM | 027XX S EMERALD AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | False | 914 | 9 | 11 | 60.0 | 20 | 1171748.0 | 1886502.0 | 2012 | 02/04/2016 06:33:39 AM | 41.844020 | -87.645207 | (41.844019513, -87.645207358) | 26.0 | 21194.0 | 58.0 | 688.0 | 48.0 | 40.0 | 23.0 | 157.0 | 7.0 | 23.706100 | 513.0 |
| 60 | 61.0 | New City | 11.9 | 29.0 | 23.0 | 41.5 | 38.9 | 12765 | 91.0 | 11419858 | JB400896 | 01/01/2012 12:00:00 AM | 047XX S WOOD ST | 1754 | OFFENSE INVOLVING CHILDREN | AGG SEX ASSLT OF CHILD FAM MBR | APARTMENT | True | True | 931 | 9 | 15 | 61.0 | 02 | NaN | NaN | 2012 | 01/24/2019 04:13:10 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16.715586 | 1139.0 |
| 61 | 62.0 | West Elsdon | 11.1 | 15.6 | 16.7 | 37.0 | 37.7 | 15754 | 69.0 | 8509166 | HV186479 | 01/01/2012 12:01:00 AM | 051XX S PULASKI RD | 1305 | CRIMINAL DAMAGE | CRIMINAL DEFACEMENT | DEPARTMENT STORE | True | False | 815 | 8 | 23 | 62.0 | 14 | 1150563.0 | 1870470.0 | 2012 | 02/10/2018 03:50:01 PM | 41.800465 | -87.723370 | (41.800464977, -87.723370404) | 35.0 | 22248.0 | 60.0 | 792.0 | 6.0 | 56.0 | 13.0 | 129.0 | 23.0 | 21.418129 | 293.0 |
| 62 | 63.0 | Gage Park | 15.8 | 23.4 | 18.2 | 51.5 | 38.8 | 12171 | 93.0 | 8688452 | HV363336 | 01/01/2012 12:00:00 AM | 055XX S HOMAN AVE | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | OTHER | False | False | 822 | 8 | 14 | 63.0 | 06 | 1154655.0 | 1867673.0 | 2012 | 02/04/2016 06:33:39 AM | 41.792709 | -87.708438 | (41.792708947, -87.708438164) | 49.0 | 21867.0 | 61.0 | 801.0 | 8.0 | 58.0 | 13.0 | 129.0 | 14.0 | 17.424946 | 563.0 |
| 63 | 64.0 | Clearing | 2.7 | 8.9 | 9.5 | 18.8 | 37.6 | 25113 | 29.0 | 9030494 | HW173536 | 01/01/2012 12:00:00 AM | 063XX W 63RD ST | 890 | THEFT | FROM BUILDING | BANK | False | False | 812 | 8 | 23 | 64.0 | 06 | 1135055.0 | 1862066.0 | 2012 | 02/10/2018 03:50:01 PM | 41.777691 | -87.780442 | (41.777690785, -87.780442441) | 35.0 | 22268.0 | 62.0 | 265.0 | 15.0 | 7.0 | 13.0 | 272.0 | 13.0 | 20.194647 | 249.0 |
| 64 | 65.0 | West Lawn | 5.8 | 14.9 | 9.6 | 33.6 | 39.6 | 16907 | 56.0 | 10244439 | HY432505 | 01/01/2012 12:00:00 AM | 039XX W 63RD PL | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | RESIDENCE | False | False | 823 | 8 | 13 | 65.0 | 11 | 1151174.0 | 1862198.0 | 2012 | 02/10/2018 03:50:01 PM | 41.777753 | -87.721346 | (41.777753427, -87.721345586) | 23.0 | 21867.0 | 63.0 | 238.0 | 15.0 | 58.0 | 13.0 | 276.0 | 23.0 | 32.592593 | 792.0 |
| 65 | 66.0 | Chicago Lawn | 7.6 | 27.9 | 17.1 | 31.2 | 40.6 | 13231 | 80.0 | 8511440 | HV188411 | 01/01/2012 12:00:00 AM | 030XX W 64TH ST | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 823 | 8 | 15 | 66.0 | 06 | 1157262.0 | 1862044.0 | 2012 | 02/04/2016 06:33:39 AM | 41.777210 | -87.699031 | (41.777209768, -87.69903082) | 44.0 | 21867.0 | 64.0 | 319.0 | 31.0 | 58.0 | 13.0 | 276.0 | 15.0 | 15.625000 | 1340.0 |
| 66 | 67.0 | West Englewood | 4.8 | 34.4 | 35.9 | 26.3 | 40.7 | 11317 | 89.0 | 8422478 | HV100112 | 01/01/2012 12:00:00 AM | 057XX S THROOP ST | 486 | BATTERY | DOMESTIC BATTERY SIMPLE | VEHICLE NON-COMMERCIAL | False | True | 713 | 7 | 16 | 67.0 | 08B | 1168636.0 | 1866805.0 | 2012 | 09/07/2021 03:41:02 PM | 41.790037 | -87.657197 | (41.790036743, -87.657196537) | 19.0 | 22257.0 | 65.0 | 297.0 | 2.0 | 23.0 | 17.0 | 266.0 | 16.0 | 15.349910 | 1531.0 |
| 67 | 68.0 | Englewood | 3.8 | 46.6 | 28.0 | 28.5 | 42.5 | 11888 | 94.0 | 8489737 | HV166954 | 01/01/2012 12:00:00 AM | 067XX S NORMAL BLVD | 1150 | DECEPTIVE PRACTICE | CREDIT CARD FRAUD | RESIDENCE | False | False | 722 | 7 | 6 | 68.0 | 11 | 1174118.0 | 1859976.0 | 2012 | 02/10/2018 03:50:01 PM | 41.771177 | -87.637298 | (41.771177146, -87.637298335) | 31.0 | 21559.0 | 66.0 | 479.0 | 32.0 | 11.0 | 17.0 | 201.0 | 4.0 | 15.333774 | 1392.0 |
| 68 | 69.0 | Greater Grand Crossing | 3.6 | 29.6 | 23.0 | 16.5 | 41.0 | 17285 | 66.0 | 8577653 | HV252006 | 01/01/2012 12:01:00 AM | 001XX E 78TH ST | 2825 | OTHER OFFENSE | HARASSMENT BY TELEPHONE | APARTMENT | False | False | 623 | 6 | 6 | 69.0 | 26 | 1178686.0 | 1853331.0 | 2012 | 02/04/2016 06:33:39 AM | 41.752840 | -87.620756 | (41.752839871, -87.620755566) | 31.0 | 21546.0 | 67.0 | 475.0 | 32.0 | 61.0 | 20.0 | 228.0 | 4.0 | 15.270766 | 1331.0 |
| 69 | 70.0 | Ashburn | 4.0 | 10.4 | 11.7 | 17.7 | 36.9 | 23482 | 37.0 | 8621247 | HV291039 | 01/01/2012 12:00:00 AM | 028XX W 84TH PL | 840 | THEFT | FINANCIAL ID THEFT: OVER $300 | RESIDENCE | False | False | 835 | 8 | 18 | 70.0 | 06 | 1158673.0 | 1848550.0 | 2012 | 02/04/2016 06:33:39 AM | 41.740151 | -87.694226 | (41.740151493, -87.694225587) | 6.0 | 4300.0 | 69.0 | 217.0 | 30.0 | 8.0 | 13.0 | 226.0 | 18.0 | 20.178042 | 544.0 |
| 70 | 71.0 | Auburn Gresham | 4.0 | 27.6 | 28.3 | 18.5 | 41.9 | 15528 | 74.0 | 12448101 | JE331623 | 01/01/2012 12:00:00 AM | 079XX S ELIZABETH ST | 1195 | DECEPTIVE PRACTICE | FINANCIAL EXPLOITATION OF AN ELDERLY OR DISABL... | RESIDENCE | False | False | 612 | 6 | 21 | 71.0 | 11 | NaN | NaN | 2012 | 08/10/2021 03:41:28 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 15.192430 | 1429.0 |
| 71 | 72.0 | Beverly | 0.9 | 5.1 | 8.0 | 3.7 | 40.5 | 39523 | 12.0 | 8692747 | HV368620 | 01/01/2012 12:00:00 AM | 090XX S OAKLEY AVE | 2825 | OTHER OFFENSE | HARASSMENT BY TELEPHONE | RESIDENCE | False | False | 2221 | 22 | 19 | 72.0 | 26 | 1162617.0 | 1844687.0 | 2012 | 02/04/2016 06:33:39 AM | 41.729470 | -87.679883 | (41.729469531, -87.679882632) | 33.0 | 22212.0 | 71.0 | 627.0 | 42.0 | 59.0 | 9.0 | 245.0 | 19.0 | 29.906542 | 352.0 |
| 72 | 73.0 | Washington Height | 1.1 | 16.9 | 20.8 | 13.7 | 42.6 | 19713 | 48.0 | 12586134 | JF104706 | 01/01/2012 12:00:00 AM | 010XX W 97TH PL | 1153 | DECEPTIVE PRACTICE | FINANCIAL IDENTITY THEFT OVER $ 300 | NaN | False | False | 2223 | 22 | 34 | 73.0 | 11 | NaN | NaN | 2012 | 01/07/2022 03:44:31 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 18.636364 | 738.0 |
| 73 | 74.0 | Mount Greenwood | 1.0 | 3.4 | 8.7 | 4.3 | 36.8 | 34381 | 16.0 | 9566017 | HX216941 | 01/01/2012 12:01:00 AM | 032XX W 114TH ST | 1751 | OFFENSE INVOLVING CHILDREN | CRIM SEX ABUSE BY FAM MEMBER | RESIDENCE | False | True | 2211 | 22 | 19 | 74.0 | 20 | 1156983.0 | 1829019.0 | 2012 | 09/07/2021 03:41:02 PM | 41.686589 | -87.700943 | (41.686589225, -87.70094317) | 33.0 | 4447.0 | 73.0 | 264.0 | 42.0 | 33.0 | 9.0 | 254.0 | 19.0 | 29.601227 | 193.0 |
| 74 | 75.0 | Morgan Park | 0.8 | 13.2 | 15.0 | 10.8 | 40.3 | 27149 | 30.0 | 8903224 | HV577354 | 01/01/2012 12:00:00 AM | 013XX W 112TH PL | 841 | THEFT | FINANCIAL ID THEFT:$300 &UNDER | RESIDENCE | False | False | 2234 | 22 | 34 | 75.0 | 06 | 1169238.0 | 1830118.0 | 2012 | 02/10/2018 03:50:01 PM | 41.689349 | -87.656048 | (41.689349439, -87.656047862) | 45.0 | 22212.0 | 74.0 | 663.0 | 22.0 | 13.0 | 9.0 | 263.0 | 21.0 | 23.643123 | 636.0 |
| 75 | 76.0 | O'Hare | 3.6 | 15.4 | 7.1 | 10.9 | 30.3 | 25828 | 24.0 | 8421756 | HV100392 | 01/01/2012 05:30:00 AM | 052XX N OAKVIEW AVE | 1365 | CRIMINAL TRESPASS | TO RESIDENCE | OTHER | True | False | 1614 | 16 | 41 | 76.0 | 26 | 1117315.0 | 1933551.0 | 2012 | 02/10/2018 03:50:01 PM | 41.974152 | -87.843985 | (41.9741522, -87.843985377) | 34.0 | 4448.0 | 75.0 | 8.0 | 29.0 | 31.0 | 12.0 | 44.0 | 41.0 | 31.203224 | 542.0 |
| 76 | 77.0 | Edgewater | 4.1 | 18.2 | 9.2 | 9.7 | 23.8 | 33385 | 19.0 | 11206130 | JB117907 | 01/01/2012 12:00:00 AM | 059XX N RIDGE AVE | 266 | CRIM SEXUAL ASSAULT | PREDATORY | RESIDENCE | False | True | 2013 | 20 | 48 | 77.0 | 02 | NaN | NaN | 2012 | 05/14/2019 04:05:19 PM | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 30.444104 | 994.0 |
| 77 | NaN | CHICAGO | 4.7 | 19.7 | 12.9 | 19.5 | 33.5 | 28202 | NaN | 8421956 | HV100653 | 01/01/2012 11:15:00 AM | 083XX S HOLLAND RD | 860 | THEFT | RETAIL THEFT | DEPARTMENT STORE | True | False | 622 | 6 | 21 | NaN | 06 | 1175640.0 | 1849717.0 | 2012 | 02/04/2016 06:33:39 AM | 41.742991 | -87.632026 | (41.742991296, -87.632025815) | 18.0 | 21554.0 | 40.0 | 1.0 | 13.0 | 59.0 | 20.0 | 236.0 | 21.0 | NaN | NaN |
import altair as alt
# Prepare the data for the grouped bar chart: melt the DataFrame
melted_data = socioeconomicMerge.melt(id_vars='COMMUNITY AREA NAME',
value_vars=['Theft Percentage', 'PERCENT HOUSEHOLDS BELOW POVERTY'],
var_name='Metric',
value_name='Percentage')
# Create the grouped bar chart
chart = alt.Chart(melted_data).mark_bar().encode(
x=alt.X('COMMUNITY AREA NAME:N', axis=alt.Axis(title='Community Area', labelAngle=-45)), # Adjust label angle for readability
y=alt.Y('Percentage:Q', axis=alt.Axis(title='Percentage (%)')), # Scale set to [0, 100]
color='Metric:N',
column='Metric:N',
order=alt.Order(
'Metric:N',
sort='ascending'
),
tooltip=['COMMUNITY AREA NAME', 'Metric', 'Percentage']
).properties(
width=500 # Adjust width as necessary
)
chart.display()
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
melted_data = socioeconomicMerge.melt(id_vars='COMMUNITY AREA NAME',
value_vars=['Theft Percentage', 'PERCENT HOUSEHOLDS BELOW POVERTY'],
var_name='Metric',
value_name='Percentage')
# Create the grouped bar chart
chart = alt.Chart(melted_data).mark_bar().encode(
x=alt.X('Metric:N', axis=alt.Axis(title='Metric')),
y=alt.Y('Percentage:Q', axis=alt.Axis(title='Percentage (%)')),
color='Metric:N',
column='COMMUNITY AREA NAME:N',
tooltip=['COMMUNITY AREA NAME', 'Metric', 'Percentage']
).properties(
width=40 # Width of each grouped bar set
)
chart.display()
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
scatter_plot = alt.Chart(socioeconomicMerge).mark_circle().encode(
x=alt.X('Theft Percentage:Q', title='Theft Percentage (%)'),
y=alt.Y('PERCENT HOUSEHOLDS BELOW POVERTY:Q', title='% Households Below Poverty'),
tooltip=['COMMUNITY AREA NAME:N', 'New Theft Percentage:Q', 'PERCENT HOUSEHOLDS BELOW POVERTY:Q'],
color=alt.Color('COMMUNITY AREA NAME:N', legend=None) # Color each point by community area (optional)
).properties(
width=600, # Adjust width as needed
height=400, # Adjust height as needed
title="Theft Percentage vs. % Households Below Poverty by Community Area"
)
scatter_plot.display()
scatter_plot = alt.Chart(socioeconomicMerge).mark_circle().encode(
x=alt.X('Theft Count:Q', title='Theft Count'),
y=alt.Y('PERCENT HOUSEHOLDS BELOW POVERTY:Q', title='% Households Below Poverty'),
size='PERCENT HOUSEHOLDS BELOW POVERTY:Q',
tooltip=['COMMUNITY AREA NAME:N', 'Theft Count:Q', 'PERCENT HOUSEHOLDS BELOW POVERTY:Q'],
color=alt.Color('COMMUNITY AREA NAME:N', legend=None) # Color each point by community area (optional)
).properties(
width=600, # Adjust width as needed
height=400, # Adjust height as needed
title="Theft Count vs. % Households Below Poverty by Community Area"
)
scatter_plot.display()
total_thefts = socioeconomicMerge['Theft Count'].sum()
total_thefts
74683.0
# create a visualization with socioeconomic factors for Chicago overall
import pandas as pd
import altair as alt
# Extracting the CHICAGO row
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'CHICAGO']
# Columns representing socioeconomic factors with percentages
columns_to_extract = [
'PERCENT HOUSEHOLDS BELOW POVERTY',
'PERCENT AGED 16+ UNEMPLOYED',
'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'
]
chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')
chicagoChart = alt.Chart(chicago_percentages).mark_bar().encode(
y=alt.Y('Factors:N', title = 'Factors'),
x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),
tooltip=('Percentage')).properties(
width = 600,
title = 'Socioeconomic Factors in All of Chicago'
)
chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Fuller Park']
# Columns representing socioeconomic factors with percentages
columns_to_extract = [
'PERCENT HOUSEHOLDS BELOW POVERTY',
'PERCENT AGED 16+ UNEMPLOYED',
'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'
]
chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')
chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='purple').encode(
y=alt.Y('Factors:N', title = 'Factors'),
x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
width = 600,
title = 'Socioeconomic Factors in Fuller Park Community Area'
)
chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Riverdale']
# Columns representing socioeconomic factors with percentages
columns_to_extract = [
'PERCENT HOUSEHOLDS BELOW POVERTY',
'PERCENT AGED 16+ UNEMPLOYED',
'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'
]
chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')
chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='orange').encode(
y=alt.Y('Factors:N', title = 'Factors'),
x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
width = 600,
title = 'Socioeconomic Factors in Riverdale Community Area'
)
chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
# highest amount of thefts according to theft count
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Near North Side']
# Columns representing socioeconomic factors with percentages
columns_to_extract = [
'PERCENT HOUSEHOLDS BELOW POVERTY',
'PERCENT AGED 16+ UNEMPLOYED',
'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'
]
chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')
chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='pink').encode(
y=alt.Y('Factors:N', title = 'Factors'),
x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
width = 600,
title = 'Socioeconomic Factors in Near North Side Community Area'
)
chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():
# lowest amount of thefts according to scatterplot
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Edison Park']
# Columns representing socioeconomic factors with percentages
columns_to_extract = [
'PERCENT HOUSEHOLDS BELOW POVERTY',
'PERCENT AGED 16+ UNEMPLOYED',
'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'
]
chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')
chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='green').encode(
y=alt.Y('Factors:N', title = 'Factors'),
x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
width = 600,
title = 'Socioeconomic Factors in Edison Park Community Area'
)
chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead. for col_name, dtype in df.dtypes.iteritems():